DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_SQL

  1. #1
    Join Date
    Dec 2000
    Posts
    2

    Question

    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]

  2. #2
    Join Date
    Aug 2000
    Location
    Ny
    Posts
    105
    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
  •  


Click Here to Expand Forum to Full Width