Re: SYS_LOB query
From: Ray Stell <stellr_at_vt.edu>
Date: Mon, 27 Oct 2014 11:37:06 -0400
Message-Id: <C52BCF94-151B-4499-AD9D-CF57CCCABF9F_at_vt.edu>
Date: Mon, 27 Oct 2014 11:37:06 -0400
Message-Id: <C52BCF94-151B-4499-AD9D-CF57CCCABF9F_at_vt.edu>
On Oct 27, 2014, at 11:29 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> select owner,table_name,column_name from dba_tab_columns where owner = 'FRED' and data_type like '%LOB';
>
> would probably be useful if there are not too many other FRED LOBs.
thanks. that’s it.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 27 2014 - 16:37:06 CET