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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 13 03:32:28 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.