Re: SQLPLUS, Date Type question

Try this :

select owner,table_name
  from all_tables t
 where exists

       (select 1
          from all_tab_columns c
         where c.owner = t.owner
           and c.table_name = t.table_name
           and c.data_type = 'DATE')

but if you are a serious Y2K tester.... try this also :

select owner,table_name
  from all_tables t
 where exists

       (select 1
          from all_tab_columns c
         where c.owner = t.owner
           and c.table_name = t.table_name
           and (c.column_name like ('%DATE%') or
                c.column_name like ('%DT%')
               )
           and c.data_type != 'DATE'
        )

;-)

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.
Received on Mon Jun 14 1999 - 15:06:09 CDT