Tuesday, 7 May 2019

Iterating over all tables in one db to create Local Folder

Scnario:- My oracle DB Having 100 Tables  and I Want Store That Tables in Local Folder And Create Tablename.csv and Store The Table Information ...

Componenets Usage:-

1.oracle Connection
2.Toracle Tablelist
3.Toracle Input
4.TfileOutputDelimted...

Job Desgin Like Below:-


Toracle TableList Wirte Code Code

Toracle Input Write logic :-

Select Schmena Dynamic




TfileoutputDelimited:-

Write File Name : Path ur director and Global Varabile of T oracle Table List Use Current Table Function...




And Run The Job:-



U can Get The All The File Database To Local Floder Using Single Job.....

No comments:

Post a Comment

Scinario Based interview Question .....

 How  To Achieve The Scenario. Input File1.csv  id,Name 1,Mahendra File2.csv City, State Hyd,Telangana File3.csv Stateid Ts I want Out put F...