+ 2
Is anyone here familiar with Oracle PL/SQL?Is it possible to print result set from cursor without using column names?If so how?
CUR_TEMP REF CURSOR contains list of queries to fetch data from multiple tables. I have a loop that opens each item of CUR_TEMP and fetch data into a variable of table_name%rowtype. 1) Is it possible for me to use a single variable that can accept data from any tables? _ I do not have the privilege to create Objects of Table type. 2)I need to print the result set(Not metadata) .Cannot mention column names of each and every table,because I have 20-25 tables with 20 or more columns in each.
2 Answers
+ 1
I don't understand your question, but I guess that into ALL_TAB_COLUMNS you can find all metadata you need.
0
Thanks for the response. But this is not what I am looking for. I'll try and edit the question.