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!

Ambiguity in the usage of select statement in "PIVOT" clause - PART I

Vysakh Suresh - 3035408Dec 21 2015 — edited Dec 22 2015

Dear All,

Kindly advise why is it that we cant use select statement inside the PIVOT phrase.

ie in the portion highlighted in bold below,

select * from(

)

PIVOT

(

Aggregate_Function<column_name_1> FOR <column_name_2> IN (select <column_name_temp> from <table_name>)

);


NB : Discussion example query created under

Thanks and Regards,

Vysakh Suresh

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 19 2016
Added on Dec 21 2015
#pivot, #select
4 comments
687 views