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: 4509
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: Mon Jun 26 00:12:24 CDT 2017

Total time taken to generate the page: 0.05076 seconds