Re: describe tables
Date: Fri, 07 Aug 1998 14:47:33 GMT
Message-ID: <35cf132b.6548275_at_192.86.155.100>
A copy of this was sent to dw724_at_cleveland.Freenet.Edu (Dennis M. Hancy) (if that email address didn't require changing) On 7 Aug 1998 14:30:59 GMT, you wrote:
>
>When executing a desc command in SQL, is there any way to list out just
>certain fields in a table? In other words, if I just wanted a list of
>the fields that end in '_ID', for instance, how would I do that?
>
>
>Dennis Hancy
>Eaton Corporation
>Cleveland, OH
not with describe, you would have to instead use something like:
SQL> select column_name, data_type, data_length
2 from user_tab_columns
3 where table_name = 'TESTING'
4 and column_name like '%\_ID' escape '\';
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Opinions are mine and do not necessarily reflect those of Oracle Corporation
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Aug 07 1998 - 16:47:33 CEST