DBMS_SQL

Hi There

Can you recommend webpage/website where I can find good examples on DBMS_SQL package

Can I use for loop while creating columns ??

source_cursor := dbms_sql.open_cursor;
dbms_sql.parse(source_cursor, 'select fld1 from trapeze.cmbc_tmptrips', dbms_sql.native);
for i in 1..v_count loop
dbms_sql.define_column(source_cursor ,i,id_var);
end loop;




Thanks

samir

[Edited by samir on 12-28-2000 at 02:04 PM]

First, if you are using Oracle 8i then it's much EZer to use EXCEUTE IMMEDIATE instead of DBMS_SQL. Look in Oracle doc's for that.