Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kachara
-
How to use pl/sql table in select queries?
Hi Dagon, Thank you for the reply. Would you suggest to use a global temporary table instead? Do you see any advantage/disadvantage over using pl/sql table? Thanks, RJ- kachara
- Post #3
- Forum: Oracle: All versions
-
How to use pl/sql table in select queries?
Hi, I have a pl/sql table as TYPE ER_SUBID_RECORD_TYPE IS RECORD ( SUBSCRIPTION_ID SUBSCRIPTIONS.SUBSCRIPTION_ID%TYPE ); TYPE ER_SUBID_TABLE_TYPE IS TABLE OF ER_SUBID_RECORD_TYPE; I basically use this to store some subscription_ids for further processing. My goal is...- kachara
- Thread
- Replies: 3
- Forum: Oracle: All versions
