OraFAQ Forum: SQL & PL/SQL » user_tab

Home » SQL & PL/SQL » SQL & PL/SQL » user_tab_columns (merged)

Tue, 16 December 2008 04:39

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

Tue, 16 December 2008 04:52

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must query dba_tab_columns.

Don't multipost your questions.

Regards
Michel

Tue, 16 December 2008 05:12

maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal

Member

THANK YOU MICHEL

IT SOLVED MY PROBLEM.

MULTIPOST WAS AN ACCIDENT.

Tue, 16 December 2008 05:17

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: Sat Dec 14 16:39:52 CST 2024