Posted by NosaLee in Oracle on 15-06-2012. Tags: Oracle Database Experience, Oracle FAQ, Oracle Q & A, Oracle Skills
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/