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: 4506
Registered: April 1998
Senior Member
Describe the table or

SELECT data_type FROM all_tab_columns WHERE table_name = '...';
Previous Topic: calling a DDL sql script from plsql block
Next Topic: Dynamic duplicate search
Goto Forum:

Current Time: Sun Feb 26 10:55:55 CST 2017

Total time taken to generate the page: 0.10852 seconds