Re: SQLPLUS, Date Type question

The sql
select owner, table_name, column_name from all_tab_columns
where data_type= 'DATE';
should do the job. Depending on the user privileges u can replace all_tab_columns with user_tab_columns or dba_tab_columns.

In article <7k3hm4$vrp$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.
>

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