• Post Reply Bookmark Topic Watch Topic
  • New Topic

Read all tables from a schema and insert values.  RSS feed

 
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 ..




 
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.
 
Seriously? That's what you're going with? I prefer this tiny ad:
Why should you try IntelliJ IDEA ?
https://coderanch.com/wiki/696337/IntelliJ-IDEA
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!