Home > IT Answers > Oracle > how to access fields of table along with thei...
Help

Question

  Asked: Jul 1 2008   10:09 AM GMT
  Asked by: Shaileshb

how to access fields of table along with their datatypes in oracle


Oracle Developer 2000, Oracle 9i, Oracle development, Developer 2000

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

Shailesh

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 1 2008  6:05 PM GMT  by Fhashmat




You need to use ALL_TAB_COLUMNS or ALL_TAB_COLS to get the columns information for a table.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register