Home » SQL & PL/SQL » SQL & PL/SQL » Tables with datatype 'LONG'
Tables with datatype 'LONG' [message #187762] Tue, 15 August 2006 07:52 Go to next message
cherryven
Messages: 13
Registered: August 2006
Junior Member
Hi,
I want to find out all the tables which has got the fields of data type 'LONG',how can I get that.

Regards,
cherry
Re: Tables with datatype 'LONG' [message #187763 is a reply to message #187762] Tue, 15 August 2006 08:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
SELECT distinct table_name
FROM   all_Tab_columns
where  data_type = 'LONG'
Re: Tables with datatype 'LONG' [message #187843 is a reply to message #187763] Wed, 16 August 2006 00:00 Go to previous message
cherryven
Messages: 13
Registered: August 2006
Junior Member
Thanks...it worked with that script..

Regards,
Cherry
Previous Topic: Needed Some suggestion On Performance --Oracle Trigger
Next Topic: Please kindly help me in this UPDATE command
Goto Forum:
  


Current Time: Sat Dec 10 16:27:52 CST 2016

Total time taken to generate the page: 0.04662 seconds