Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Read all tables from a schema and insert values.

 
Thirumurugan Sivaji
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I want to read all the tables from a schema, and read all columns for the particular table, based on the column datatype and its length i need to insert the values .

Ex:
wil return all the tables, from the result i need to loop the resutset









procedure for INSERTRECORDS:
------------------------------------






Problem:

From the 1st procedure im getting each table and pass the value to second procedure. From the second procedure with in the cursor i need to get all the columns
in a single step, so that i can insert values into table ..




 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can create the sql as varchar2 variable then use execute immediate command to execute it using your variables.

Regards,

Fatih.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic