How to retrieve oracle table structure at run time

Highlighted
Seven 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 

Highlighted
Thirteen 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!

Seven Stars

Re: How to retrieve oracle table structure at run time

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

Highlighted
Thirteen 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!

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog