Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

distinct keyword Error

V prasadMay 6 2011 — edited May 6 2011
SELECT  DISTINCT(FC.FLFFCONFIGID) AS "idNum", FC.VENDOR AS "provider", 
                                NVL(VD.NAME,FC.NAME) AS "providorName", FC.FORMAT AS "format" 
                         FROM FLFFCONFIG FC, VENDORDETL VD WHERE FC.VENDOR = VD.VENDOR(+)
                         
for above query i am getting result,

while i am using in xml format like below, i am getting error;

SELECT XMLAGG(XMLELEMENT("listItem", XMLFOREST( DISTINCT(FC.FLFFCONFIGID) AS "idNum", FC.VENDOR AS "provider", 
                                NVL(VD.NAME,FC.NAME) AS "providorName", FC.FORMAT AS "format" ))).GETCLOBVAL()
                         FROM FLFFCONFIG FC, VENDORDETL VD WHERE FC.VENDOR = VD.VENDOR(+)
Error at Command Line:1 Column:48
Error report:
SQL Error: ORA-00936: missing expression
00936. 00000 -  "missing expression"
*Cause:    
*Action:

i think i am using distinct keyword.
error is in that , how to eliminate.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2011
Added on May 6 2011
4 comments
224 views