Re: need help with script
- From: Mohammed Mehraj Hussain <mhdmehraj@xxxxxxxxx>
- To: HelenJMitchell@xxxxxxxxxxx
- Date: Wed, 23 Sep 2009 18:54:32 +0530
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@xxxxxxxxxxx>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.
>
Other related posts: