| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Oracle SQL*Plus - how do i list all tables containing column name 'id'|
| 4:09 pm on Feb 2, 2006 (gmt 0)|
Anyone know how to list/print out all table names that contain the column name 'id', for example, in SQL*Plus from an Oracle 8i database?
| 4:25 pm on Feb 2, 2006 (gmt 0)|
'Fraid I haven't got an Oracle installation at hand right now, but this might work:
SELECT TABLE_NAME FROM USER_TAB_COLUMNS
| 10:11 am on Feb 3, 2006 (gmt 0)|
thanks zCat! it worked =)
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved