Unanswered: Output records without specifying list field names
Below is the SQL to output a field of a variable table name.
Anyone know how to output the entire record without specifying the list field names? Need your advise. Thanks.
FOR siWO_rec IN curSI_WO LOOP
sql_stmt := 'SELECT * FROM ' || siWO_rec.TABLENAME;
OPEN si_cv FOR sql_stmt;
FETCH si_cv INTO si_rec;
EXIT WHEN si_cv%NOTFOUND;
Re: Output records without specifying list field names
You can't do it this way without using the field names. However, if you use the DBMS_SQL package you don't need to know the field names: you can extract the column values one at a time into a variable and output them.