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