How to retrieve oracle table structure at run time

Six Stars

How to retrieve oracle table structure at run time

Hi,

 

Can anybody let us know how can we reterive Oracle table structure at run time and use that same structure for tFileinputDelimited component as a schema ?

 

 

Regards,

Vivek 

Eleven Stars

Re: How to retrieve oracle table structure at run time

you can use sys.All_Objects views you may need more rights to access sys tables ask to your oracle admin

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Six Stars

Re: How to retrieve oracle table structure at run time

Thats fine,how can we use that table structure as tFileInputDelimited schema ?

Eleven Stars

Re: How to retrieve oracle table structure at run time

you can use dynamic type who include the structure.
or just use field name (delimited file have not type)

Francois Denis

Tag as "solved" for others! Kudos to thanks!