в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T10:01:06Z

1 версия

Новая страница

==CAT table==



<source lang="sql">

SQL> SELECT * FROM CAT where rownum < 10;
TABLE_NAME TABLE_TYPE
------------------------------ -----------
ACCESS$ TABLE
ALERT_QT TABLE
ALL_ALL_TABLES VIEW
ALL_APPLY VIEW
ALL_APPLY_CONFLICT_COLUMNS VIEW
ALL_APPLY_DML_HANDLERS VIEW
ALL_APPLY_ENQUEUE VIEW
ALL_APPLY_ERROR VIEW
ALL_APPLY_EXECUTE VIEW
9 rows selected.
SQL>
SQL>

</source>

==Query cat for table name and type==



<source lang="sql">

SQL>
SQL> create table emp
2 ( empno NUMBER(4) constraint E_PK primary key
3 , ename VARCHAR2(8)
4 , init VARCHAR2(5)
5 , job VARCHAR2(8)
6 , mgr NUMBER(4)
7 , bdate DATE
8 , sal NUMBER(6,2)
9 , comm NUMBER(6,2)
10 , deptno NUMBER(2) default 10
11 ) ;
Table created.
SQL> create synonym e for emp;
Synonym created.
SQL>
SQL> describe e
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(8)
INIT VARCHAR2(5)
JOB VARCHAR2(8)
MGR NUMBER(4)
BDATE DATE
SAL NUMBER(6,2)
COMM NUMBER(6,2)
DEPTNO NUMBER(2)
SQL>
SQL> select * from e;
no rows selected
SQL>
SQL> select * from cat;
TABLE_NAME TABLE_TYPE
--------------- -----------
MYSTATS TABLE
S SEQUENCE
WORKING_CUSTOME TABLE
RS

EMP_HQ VIEW
CUST_WITH_VARRA TABLE
Y_TEMP_TABLE

P1 TABLE
V VIEW
IT TABLE
TABLE_NAME TABLE_TYPE
--------------- -----------
CUST_NO_KEY_TAB TABLE
LE

AVG_SAL VIEW
DEMO TABLE
EMPDEPT_V VIEW
CUSTLOG TABLE
IX TABLE
EMP_DELTAS TABLE
PARMS TABLE

TABLE_NAME TABLE_TYPE
--------------- -----------
PASSWORD_AUDIT TABLE
WO_SEQ SEQUENCE
DEPT_SAL VIEW
DEPT$AUDIT TABLE
ALL_ORACLE_ERRO VIEW
RS

INVENTORY_TBL TABLE
INVENTORY_VIE VIEW
TMP TABLE
SEQ SEQUENCE
TABLE_NAME TABLE_TYPE
--------------- -----------
FRIENDIDSEQ SEQUENCE
TOP_EMP VIEW
EMP_BONUS VIEW
SHARED VIEW
SYSTEM_STATS TABLE
EMP TABLE
EMPLOYEETEMPTAB TABLE
LE

TEMP_TABLE TABLE

TABLE_NAME TABLE_TYPE
--------------- -----------
PHONE_LIST VIEW
EMPTEMPTABLE TABLE
P TABLE
WORKING_EMPLOYE TABLE
ES

E SYNONYM
WORKING_EMPS TABLE
MYTABLE1 TABLE

40 rows selected.
SQL>
SQL> select synonym_name, table_owner, table_name
2 from user_synonyms;
SYNONYM_NAME TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------ ---------------
E sqle EMP

SQL>
SQL> drop synonym e;
Synonym dropped.
SQL>
SQL> drop table emp;
Table dropped.

</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/System Tables Views/CAT - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия