Home » SQL & PL/SQL » SQL & PL/SQL » datatype
datatype [message #253317] Mon, 23 July 2007 08:23 Go to next message
Messages: 112
Registered: July 2006
Senior Member

Is there a code where I can find out the datatype of all fields in a table?

Re: datatype [message #253318 is a reply to message #253317] Mon, 23 July 2007 08:27 Go to previous message
Frank Naude
Messages: 4522
Registered: April 1998
Senior Member
Describe the table or

SELECT data_type FROM all_tab_columns WHERE table_name = '...';
Previous Topic: Need function which takes input as sql query and returns column number
Next Topic: XML
Goto Forum:

Current Time: Tue Aug 22 06:19:48 CDT 2017

Total time taken to generate the page: 0.20786 seconds