Home » SQL & PL/SQL » SQL & PL/SQL » user_tab_columns (merged)
user_tab_columns (merged) [message #376140] Tue, 16 December 2008 04:39 Go to next message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
hi,

I need to know the columnnames of tables from another schema. How do i do it.
I tried using
  SELECT * FROM anotherschema.user_tab_columns WHERE ROWNUM < 10;

but i get error msg
ORA-00942: table or view does not exist


Is there any way i could access the user_tab_column table of another schema.

thank you Shocked
Re: user_tab_columns (merged) [message #376143 is a reply to message #376140] Tue, 16 December 2008 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must query dba_tab_columns.

Don't multipost your questions.

Regards
Michel
Re: user_tab_columns (merged) [message #376146 is a reply to message #376143] Tue, 16 December 2008 05:12 Go to previous messageGo to next message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
THANK YOU MICHEL

IT SOLVED MY PROBLEM.

MULTIPOST WAS AN ACCIDENT.
Re: user_tab_columns (merged) [message #376147 is a reply to message #376143] Tue, 16 December 2008 05:17 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
or All_Tab_Columns - that will show you the columns of all the tables you have been granted SELECT on.
Previous Topic: NUMBER or NUMBER(12)
Next Topic: How to call in through pl/sql to get result
Goto Forum:
  


Current Time: Thu Dec 08 10:45:32 CST 2016

Total time taken to generate the page: 0.20129 seconds