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

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

Thanks
Stefan
Re: datatype [message #253318 is a reply to message #253317] Mon, 23 July 2007 08:27 Go to previous message
Frank Naude
Messages: 4502
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: Fri Dec 09 03:44:12 CST 2016

Total time taken to generate the page: 0.11224 seconds