Re: SQLPLUS data type question
From: Haggai <haggai_shachar_at_hotmail.com>
Date: Tue, 15 Jun 1999 10:09:57 +0300
Message-ID: <7k523f$732$1_at_news.netvision.net.il>
Date: Tue, 15 Jun 1999 10:09:57 +0300
Message-ID: <7k523f$732$1_at_news.netvision.net.il>
select table_name, column_name from all_tab_columns where data_type = upper ('date');
Haggai. haggai_shachar_at_hotmail.com
lcampbell7272_at_my-deja.com wrote in message <7k3i39$2i$1_at_nnrp1.deja.com>...
>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.
Received on Tue Jun 15 1999 - 09:09:57 CEST