File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Read all tables from a schema and insert values. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Read all tables from a schema and insert values." Watch "Read all tables from a schema and insert values." New topic
Author

Read all tables from a schema and insert values.

Thirumurugan Sivaji
Greenhorn

Joined: Mar 03, 2009
Posts: 20
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 ..





Warm Regards,

Thirumurugan Sivaji

Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
You can create the sql as varchar2 variable then use execute immediate command to execute it using your variables.

Regards,

Fatih.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Read all tables from a schema and insert values.