• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Read all tables from a schema and insert values.

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic