Retrieve All Columns of Table Type
Hi,
I declare a table type with a structure of all columns of a table from the DB.
when I retrieve the data from this table, I want to write into text file all the columns for each record (with for loop). I don't want to write the column name for each column, because the table consist many columns. I search for systax for retrieve all the columns.
I declare a table type with a structure of all columns of a table from the DB.
when I retrieve the data from this table, I want to write into text file all the columns for each record (with for loop). I don't want to write the column name for each column, because the table consist many columns. I search for systax for retrieve all the columns.
(The columns in the table type is identical to the columns of the table in database).
declare
type tbl_T is table of my_table%rowtype index by binary_integer;
l_file_out utl_file.file_type;
0