DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Merge clause retrieves ORA-00923 FROM keyword not found where expected

Threaded View

  1. 04-23-2009, 08:26 AM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Distinct()?

    The DISTINCT keyword is NOT A FUNCTION!!!!

    "DISTINCT(ESTADO)" is incorrect, remove it because you already have a GROUP BY aggregate on "ESTADO" -- and try again.

    Last edited by LKBrwn_DBA; 04-23-2009 at 08:28 AM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width