Posted by Mladen Gogala on 07/05/07 23:45

On Mon, 02 Jul 2007 19:31:52 +0100, Andy Hassall wrote:

>>It does, but it will not work for views or V$ tables.
>
> Um, yes it will. Views' columns appear in USER_TAB_COLUMNS.

It does work for views, but not for V$ tables:
SQL> select column_name from dba_tab_columns
2 where table_name='V$PROCESS';

no rows selected

SQL> select column_name from dba_tab_columns
2 where table_name='V$SESSION';

no rows selected

SQL> select column_name from dba_tab_columns
2 where table_name='DBA_USERS';

COLUMN_NAME
-----------------------------------
USERNAME
USER_ID
PASSWORD
ACCOUNT_STATUS
LOCK_DATE
EXPIRY_DATE
DEFAULT_TABLESPACE
TEMPORARY_TABLESPACE
CREATED
PROFILE
INITIAL_RSRC_CONSUMER_GROUP
EXTERNAL_NAME

12 rows selected.



--
http://www.mladen-gogala.com

[Back to original message]