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
:
Subject:RE: tables and views
Join TAB$ and COL$ directly (on OBJ#) and your problem is gone. You'll get only columns that
belong to tables. You should also set _disable_suboptimal_app_design to TRUE
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED
Subject: RE: tables and views
Join
TAB$ and COL$ directly (on OBJ#) and your problem is gone. You'll get only
columns that
belong to tables. You should also set _disable_suboptimal_app_design to
TRUE
--Mladen GogalaOracle DBA
-Original Message-From: [EMAIL
Title: RE: tables and views
You need to look into all_objects also. It tells you if it is a table or view.
SELECT DISTINCT c.owner, c.table_name, o.object_type
FROM all_tab_columns c, all_objects o
WHERE c.table_name = o.object_name
AND c.owner = o.owner
AND o.object_type = 'TABLE
of something like list all the table columns, or list
all the view columns) then you should join to ALL_OBJECTS.
-Original Message-From: AK
[mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:19
PMTo: Multiple recipients of list ORACLE-LSubject:
tables and views
How
How to diiferentiate views and tables in all_tables
and all_tab_columns . which column and what criteria can return only tables
??
-ak
PROTECTED] On Behalf Of
AKSent: Friday, August 08, 2003 2:19 PMTo: Multiple
recipients of list ORACLE-LSubject: 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
Note