Views aren’t in all_tables, they are in all_views.

 

Igor Neyman, OCP DBA

[EMAIL PROTECTED]

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AK
Sent: Friday, August 08, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Subject: tables and views

 

How to diiferentiate views and tables in all_tables and all_tab_columns . which column and what criteria can return only tables ??

 

-ak

Reply via email to