-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|