Oracle PL/SQL Tutorial/System Tables Data Dictionary/object table — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
Admin (обсуждение | вклад) м (1 версия) |
(нет различий)
|
Текущая версия на 13:08, 26 мая 2010
List tables and views from object_table
<source lang="sql">
SQL> SQL> select object_name, object_type
2 from obj 3 where object_type in ("TABLE","VIEW") 4 and rownum < 50 5 order by object_type, object_name;
OBJECT_NAME
OBJECT_TYPE
AVAIL_TRACE_FILES TABLE DDL_AUDIT TABLE DUMMY TABLE HAZARD_LEVEL_T TABLE HOME_ADDRESES_TAB TABLE HOME_ADDRESS_LIST TABLE OBJECT_NAME
OBJECT_TYPE
I1 TABLE I2 TABLE INTEREST TABLE LOG_TABLE TABLE MAP TABLE OUTRAIN OBJECT_NAME
OBJECT_TYPE
TABLE P TABLE PARTS TABLE PUBLICATION TABLE SITE_TAB TABLE T1_TIMES TABLE
OBJECT_NAME
OBJECT_TYPE
TEST_BFILE TABLE WORKING_CUSTOMERS TABLE APPLICATION_USERS VIEW AUTHOR_PUBLICATION VIEW AVG_EVALUATIONS VIEW COURSE_DAYS VIEW OBJECT_NAME
OBJECT_TYPE
CRS_COURSE_SCHEDULE VIEW CRS_OFFERINGS VIEW DEPT20_V VIEW DEPT_OR VIEW EMP_V VIEW EMP_VIEW OBJECT_NAME
OBJECT_TYPE
VIEW HRC_ORG_SITE VIEW SALES_BY_ATLAS_V VIEW SALES_PER_PERSON_V VIEW USER_AVAIL_TRACE_FILES VIEW
33 rows selected. SQL></source>