Re: How to do this in ProC???
From: Kim Ng <kimmng_at_pebbles.uswnvg.com>
Date: 18 Nov 1994 01:36:41 GMT
Message-ID: <3ah0f9$60h_at_fred.uswnvg.com>
Kim Ng
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!) Received on Fri Nov 18 1994 - 02:36:41 CET
Date: 18 Nov 1994 01:36:41 GMT
Message-ID: <3ah0f9$60h_at_fred.uswnvg.com>
There is actually a simple solution. In version 6, use the ORACLE supplied view "all_tab_columns". It has all the info you need such as table owner, column name, column type, column length, etc. (look for similar view in version 7). You have to have access to the tables of that owner, though, in order to see those tables. DBA priviledge comes to mind <grin>
If you are only interested in a list, SQLPLUS can do it.
Kim Ng
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!) Received on Fri Nov 18 1994 - 02:36:41 CET