Is anyone here familiar with Oracle PL/SQL?Is it possible to print result set from cursor without using column names?If so how? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 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.

8th Mar 2017, 12:26 PM
Maha Devan
Maha Devan - avatar
2 Answers
+ 1
I don't understand your question, but I guess that into ALL_TAB_COLUMNS you can find all metadata you need.
8th Mar 2017, 3:18 PM
Giampaolo Bolzonella
Giampaolo Bolzonella - avatar
0
Thanks for the response. But this is not what I am looking for. I'll try and edit the question.
8th Mar 2017, 4:05 PM
Maha Devan
Maha Devan - avatar