Skip to Main Content
Forums

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!

UNPIVOT

thinkingeyeAug 27 2010 — edited Aug 27 2010
Can anyone please tell me what's wrong with the following query? I'm using TOAD 
 SELECT *
  FROM   bin_data
   UNPIVOT (
                direction                           
            FOR bin_data                            
            IN  (bin_1_data, bin_2_data, bin_3_data) 
           );
I'm getting the following error:
ORA-00933: SQL command not properly ended

Thanks
PS: Its oracle 10g database

Edited by: thinkingeye on Aug 27, 2010 10:43 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2010
Added on Aug 27 2010
6 comments
1,776 views