Re: SQLPLUS, Date Type question

From: <tedchyn_at_yahoo.com>
Date: Mon, 14 Jun 1999 18:58:45 GMT
Message-ID: <7k3jcv$jq$1@nnrp1.deja.com>

In article <7k3hm5$vrq$1_at_nnrp1.deja.com>, lcampbell7272_at_my-deja.com wrote:
> I am a Y2K tester, and I am trying to find an
> SQLPLUS command to list all the field where the
> Data Type is equal to 'DATE', from ALL_TABLES.
> Does anyone know the command in order to
> retrieved the desired information.
>
> Thanks,
> Y2K Tester
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

y2k,
select owner,table_name,column_name
from sys.dba_tab_colimns
where data_type='DATE';
Ted

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 14 1999 - 13:58:45 CDT