Seek The Sun Slowly

Q by Shaileshb

Dear Oracle gurus
I am using oracle 9I. i want to access fields of table along with their datatypes at runtime..
to see structure of table ‘desc’ command i used.. but at runtime how i can know datatypes or fields of a table.
Thanks in advance

Re by Fhashmat

You need to use ALL_TAB_COLUMNS or ALL_TAB_COLS to get the columns information for a table.

Original Address: http://itknowledgeexchange.techtarget.com/itanswers/how-to-access-fields-of-table-along-with-their-datatypes-in-oracle/