Re: need help with script

From: Mohammed Mehraj Hussain <mhdmehraj_at_gmail.com>
Date: Wed, 23 Sep 2009 18:54:32 +0530
Message-ID: <b081c0a50909230624l192d2fdai20833bf2221d8857_at_mail.gmail.com>

select DISTINCT table_name ,OWNER from dba_tab_columns where OWNER NOT IN ('SYS','SYSTEM')
AND DATA_TYPE <>'LONG'

Regards,
Mohammed

On Wed, Sep 23, 2009 at 6:41 PM, Helen Mitchell <HelenJMitchell_at_comcast.net>wrote:

>
>
> I need a script that will select the owner and table names for the
> user-defined schemas that do not have any columns defined with a datatype =
> LONG. The script need to skip the table if any column is defined as a
> datatype = LONG.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 23 2009 - 08:24:32 CDT