Re: SQLPLUS data type question

IF U WANT TO SEE THE COLUMN NAMES WITH THE DATE DATATYPE THEN U CAN GIVE THE FOLLOWING COMMAND. "SELECT COLUMN_NAME,DATA_TYPE FROM USER_TAB_COLUMNS WHERE TABLE_NAME='EMP' AND
DATA_TYPE='DATE'" SHAILAJA <lcampbell7272_at_my-deja.com> wrote in message news: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 - 22:24:59 CEST