Home » SQL & PL/SQL » SQL & PL/SQL » oracle user_views.
oracle user_views. [message #97] Mon, 14 January 2002 01:17 Go to next message
camelia
Messages: 3
Registered: January 2002
Junior Member
How can I find out what views already exists for Oracle. For example user_tab_columns.
Does exist a view like user_tab_columns but which returns only information regarding tables not tables and views.
thanks.
Re: oracle user_views. [message #98 is a reply to message #97] Mon, 14 January 2002 02:19 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

u can get same information with this query

select * from USER_tab_COLUMNS where table_name IN (SELECT VIEW_NAME FROM USER_VIEWS)

cheers
pratap
Previous Topic: TRIGGER HELP
Next Topic: Tablespace Growth When Adding New Tables
Goto Forum:
  


Current Time: Mon Aug 03 04:44:33 CDT 2020