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!

CTE'S in Oracle

877170Sep 6 2011 — edited Sep 6 2011
I am a new developer on Oracle 10g...Can i use CTES(common table expressions) in PL/SQl as in SQl....

If yes a brief example can help me...thank you

What i am basically ttring to do is slect some fields from group of tables and use those fields in a fucntion ...i need these fields only for the scope of the function..

which is best method...

Edited by: 874167 on Sep 6, 2011 9:12 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2011
Added on Sep 6 2011
13 comments
7,775 views