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: 4507
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 Mar 26 23:58:54 CDT 2017

Total time taken to generate the page: 0.13816 seconds