oracle實驗記錄 (oracle 資料字典)

讀書筆記 eygle 深入解析oracle
實驗一遍加深理解

oracle資料字典表
(obj$之類)
ORACLE_HOME/RDMS/ADMIN/SQL.BSQ
建立這些字典表 (create database 時候會呼叫sql.bsq)

create table obj$                                            /* object table */
( obj#          number not null,                            /* object number */
/* DO NOT CREATE INDEX ON DATAOBJ# AS IT WILL BE UPDATED IN A SPACE
   * TRANSACTION DURING TRUNCATE */
dataobj#      number,                          /* data layer object number */
owner#        number not null,                        /* owner user number */
name          varchar2("M_IDEN") not null,                  /* object name */
namespace     number not null,         /* namespace of object (see KQD.H): */
/* 1 = TABLE/PROCEDURE/TYPE, 2 = BODY, 3 = TRIGGER, 4 = INDEX, 5 = CLUSTER, */

從註釋可以看到OBJ#=OBJECT_ID(ALL_OBEJCETS.OBJECT_ID,DBA_OBJECTS.OBJECTS_ID,USER_OBJECTS.OBJECTS_ID)
dataobj#=data_object_id /* data layer object number */
區別是OBJ#一但分配就不改變了
dataobj#是於物理的儲存有關係的，就是物件的物理號，隨物件物理結構的改變而改變

SQL> select object_id,data_object_iD from dba_objects where object_name='T2';

OBJECT_ID DATA_OBJECT_ID
---------- --------------
52658 52658

SQL> truncate table xh.t2;

表被截斷。

SQL> select object_id,data_object_iD from dba_objects where object_name='T2';

OBJECT_ID DATA_OBJECT_ID
---------- --------------
52658 53317(因為truncate 導致物件物理結構改變，truncate修改資料字典並不實際回收資料，然後對物件重新定位data_object_id改變)
所以可以看到註釋中說不要dataobJ# column列建立index

SQL> select object_id from user_objects where object_name='T4';

OBJECT_ID
----------
53027
執SQL> alter session set sql_trace=true;

會話已更改。

SQL> drop table t3;

表已刪除。
行DML(特定)，DDL時候 ORACLE 會自動對資料字典操作

PARSING IN CURSOR #33 len=29 dep=1 uid=0 ct=7 lid=0 tim=15412874138 hv=1088688876 ad='1b40120c'
delete TAB$ where obj#=:1 都會換成類似的dml從資料字典中刪除資料
END OF STMT

靜態資料字典VIEW ：ALL_(當前使用者可訪問的所有物件)，DBA_(DB中所有物件，需要是DBA ROLE,OR SELECT_CATALOG_ROLE),user_(當前使用者擁有的物件)

SQL> conn xh/a831115
已連線。
SQL> select * from session_roles;

ROLE
------------------------------
DBA~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~XH 有dba role
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
SCHEDULER_ADMIN
WM_ADMIN_ROLE
JAVA_ADMIN

ROLE
------------------------------
JAVA_DEPLOY
XDBADMIN
XDBWEBSERVICES
OLAP_DBA

已選擇15行。
SQL> select count(*) from user_tables;

COUNT(*)
----------
2

SQL> select count(*) from all_tables;

COUNT(*)
----------
1584

SQL> select count(*) from dba_tables;

COUNT(*)
----------
1584

建立這些靜態資料字典的VIEW 來自 oracle_home/rdbms/admin/catalog.sql

create or replace view USER_TABLES
(TABLE_NAME, TABLESPACE_NAME, CLUSTER_NAME, IOT_NAME, STATUS,
where o.owner# = userenv('SCHEMAID')~~~~~~~~~SCHEMAID returns the id of the schema for the current user. This id is used
and o.obj# = t.obj#

通過這個USERENV函式限制只輸出屬於current user的表

**************注意userenv()這個函式比較有用 **********
SQL> conn xh/a831115
已連線。
SQL> select userenv('SCHEMAID') from dual;

USERENV('SCHEMAID')
-------------------
61
SQL> select username from dba_users where user_id=61;

USERNAME
------------------------------
XH~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~只返回屬於 user xh的

create or replace view DBA_TABLES
    (OWNER, TABLE_NAME, TABLESPACE_NAME, CLUSTER_NAME, IOT_NAME, STATUS,
     PCT_FREE, PCT_USED,
     INI_TRANS, MAX_TRANS,
     INITIAL_EXTENT, NEXT_EXTENT,
where o.owner# = u.user#*******返回DB中所有USER的表

create or replace view ALL_TABLES
    (OWNER, TABLE_NAME, TABLESPACE_NAME, CLUSTER_NAME, IOT_NAME, STATUS,
where o.owner# = u.user#
and (o.owner# = userenv('SCHEMAID')
       or o.obj# in
            (select oa.obj#
             from sys.objauth$ oa
             where grantee# in ( select kzsrorol
                                 from x$kzsro
                               )
            )
       or /* user has system privileges */
         exists (select null from v$enabledprivs
                 where priv_number in (-45 /* LOCK ANY TABLE */,
                                       -47 /* SELECT ANY TABLE */,~~~~~~~~存在這樣的限制（DBA_中沒有限制）
                                       -48 /* INSERT ANY TABLE */,
                                       -49 /* UPDATE ANY TABLE */,
                                       -50 /* DELETE ANY TABLE */)

create or replace public synonym ALL_TABLES for ALL_TABLES 上面建立的是一個VIEW 為這個VIEW建立同譯詞（USER查詢時實際是查這個同譯詞）
/
grant select on ALL_TABLES to PUBLIC with grant option 將SELECT ON ALL_TABLES給PBULIC ROLE，且可以授予其他USER
grant select on DBA_TABLES to select_catalog_role 可以看到 DBA_TABLES 給了SELECT_catalog_role,不能轉授予其他USER
/

SQL> create user test identified by a123;

使用者已建立。

SQL> grant connect to test;

授權成功。

SQL> grant resource to test;

授權成功。

SQL> conn test/a123
已連線。
SQL> select count(*) from all_tables;

COUNT(*)
----------
91

SQL> select count(*) from dba_tables;
select count(*) from dba_tables
*
第 1 行出現錯誤:
ORA-00942: 表或檢視不存在

SQL> conn / as sysdba
已連線。
SQL> grant select_catalog_role to test
2 ;

授權成功。

SQL> conn test/a123
已連線。
SQL> select count(*) from dba_tables;

COUNT(*)
----------
1584

SQL> grant select_catalog_role to xh;***************
grant select_catalog_role to xh
*
第 1 行出現錯誤:
ORA-01932: ADMIN 選項未授權給角色 'SELECT_CATALOG_ROLE'

動態效能VIEW

DB啟動時 ORACLE 動態建立x$ table,又根據 x$ table 動態建立了 V$，gv$ VIEW ，動態的反映DB情況

GV$ 與V$區別就是 gv$ global view 針對 RAC
SQL> select inst_id from gv$instance;

INST_ID~~~~~~~~~~~~INSTANCE ID
----------
1
看下建立語句
SQL> select view_definition from v$fixed_view_definition where view_name='V$INST
ANCE';

VIEW_DEFINITION
--------------------------------------------------------------------------------

select INSTANCE_NUMBER , INSTANCE_NAME , HOST_NAME , VERSION , STARTUP_TIME , S

TATUS , PARALLEL , THREAD# , ARCHIVER , LOG_SWITCH_WAIT , LOGINS , SHUTDOWN_PEND

ING, DATABASE_STATUS, INSTANCE_ROLE, ACTIVE_STATE, BLOCKED from GV$INSTANCE wher

e inst_id = USERENV('Instance')~~~~~~~~~~~~~~~~~~~~~~可以看到v$是針對當前INSTANCE

SQL> select USERENV('Instance') from dual;

USERENV('INSTANCE')
-------------------
1

SQL> select view_definition from v$fixed_view_definition where view_name='GV$INS
TANCE';

VIEW_DEFINITION
--------------------------------------------------------------------------------

select ks.inst_id,ksuxsins,ksuxssid,ksuxshst,ksuxsver,ksuxstim,decode(ksuxssts,0

,'STARTED',1,'MOUNTED',2,'OPEN',3,'OPEN MIGRATE','UNKNOWN'),decode(ksuxsshr,0,'N

O',1,'YES',2,NULL),ksuxsthr,decode(ksuxsarc,0,'STOPPED',1,'STARTED','FAILED'),de

code(ksuxslsw,0,NULL,2,'ARCHIVE LOG',3,'CLEAR LOG',4,'CHECKPOINT', 5,'REDO

GENERATION'),decode(ksuxsdba,0,'ALLOWED','RESTRICTED'),decode(ksuxsshp,0,'NO','

YES'),decode(kvitval,0,'ACTIVE',2147483647,'SUSPENDED','INSTANCE RECOVERY'),deco

de(ksuxsrol,1,'PRIMARY_INSTANCE',2,'SECONDARY_INSTANCE','UNKNOWN'), decode(qui_s

tate,0,'NORMAL',1,'QUIESCING',2,'QUIESCED','UNKNOWN'), decode(bitand(ksuxsdst, 1

), 0, 'NO', 1, 'YES', 'NO') from x$ksuxsinst ks, x$kvit kv, x$quiesce qu where k

vittag = 'kcbwst'~~~~~~~~~~~~~~~~~GV 沒這個限制

create or replace view v_$librarycache as select * from v$librarycache;
create or replace public synonym v$librarycache for v_$librarycache;
grant select on v_$librarycache to select_catalog_role;
可以看到oracle 先建立 v_$librarycache 這個VIEW（基於 v$librarycache(基於x$) ）
對 v_$librarycache 又建立 v$librarycache SYNONYM同譯詞
使用者訪問用的是同譯詞

create or replace view gv_$sqlstats as select * from gv$sqlstats;
create or replace public synonym gv$sqlstats for gv_$sqlstats;
grant select on gv_$sqlstats to select_catalog_role;~~~~~~~可以看到要訪問gv_$sqlstats必須要select_catalog_role

SQL> conn tr/a123
已連線。
SQL> select * from session_roles;

ROLE
------------------------------
CONNECT~~~~~~~~~~~~~~~~~~~沒有select_catalog_role ROLE

SQL> desc gv$sqlstats;
ERROR:
ORA-04043: 物件 "SYS"."GV_$SQL" 不存在~~~~~~~~~可以看到error 實際查詢的是GV_$

SQL> conn / as sysdba
已連線。
SQL> create user tr identified by a123;

使用者已建立。

SQL> grant connect,resource to tr;

授權成功。

SQL> grant select_catalog_role to tr;

授權成功。

SQL> conn tr/a123
SQL> select count(*) from v$session;

COUNT(*)
----------
23

SQL> ed
已寫入 file afiedt.buf

1 create or replace procedure tr
2 as
3 type a is table of v$session%rowtype;
4 b a;
5 begin
6 select * bulk collect into b from v$session ;
7 for i in 1..b.count loop
8 dbms_output.put_line(b(1).sid);
9 end loop;
10* end;
SQL> /

警告: 建立的過程帶有編譯錯誤。

SQL> show error
PROCEDURE TR 出現錯誤:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/1      PL/SQL: Item ignored
3/20     PLS-00201: 必須宣告識別符號 'V$SESSION'
6/1      PL/SQL: SQL Statement ignored
6/35     PL/SQL: ORA-00942: 表或檢視不存在~~~~~~~~~~~~~~~~~~~
8/1      PL/SQL: Statement ignored
8/27     PLS-00487: 對變數 'V$SESSION%ROWTYPE' 的引用無效
SQL>
原理很簡單查詢v$session 這個SYNONYM 是通過 ROLE 查詢到的(類似grant select on gv_$sqlstats to select_catalog_role 許可權,角色實驗中也有實驗到)，procedure中需要

直接授予的許可權而不是通過role（role要登陸才能啟用 procedure,trigger中無效）
SQL> conn / as sysdba
已連線。
SQL> grant select on v_$session to tr ~~~~~~~授予直接檢視v_$librarycache 這個基於（基於 v$librarycache(基於x$) ）的view
2 ;

授權成功。
SQL> alter procedure tr.tr compile;

過程已更改。

所有的 X$表，V$ VIEW，GV$ view

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> select count(*) from v$fixed_table where name like 'X$%';

COUNT(*)
----------
613

SQL> select count(*) from v$fixed_table where name like 'GV$%';

COUNT(*)
----------
372

SQL> select count(*) from v$fixed_table where name like 'V$%';

COUNT(*)
----------
396

每個階段的v$
NOMOUNT：可以檢視與spfile相關的VIEW 可以查詢

例如
SQL> select count(*) from v$parameter;~************查不了
select count(*) from v$parameter
*
第 1 行出現錯誤:
ORA-01220: ?????????????????

SQL> select count(*) from v$spparameter;

COUNT(*)
----------
265

SQL> select count(*) from v$sga;

COUNT(*)
----------
4

SQL> select count(*) from v$bh;

COUNT(*)
----------
0

SQL> select count(*) from v$instance;

COUNT(*)
----------
1

SQL> alter database mount;載入控制檔案可以查詢與controlfile相關的VIEW

SQL> select count(*) from v$database;

COUNT(*)
----------
1

SQL> select count(*) from v$datafile;

COUNT(*)
----------
6

SQL> select count(*) from v$datafile_header;

COUNT(*)
----------
6

SQL> select count(*) from v$log;

COUNT(*)
----------
3
SQL> alter database open;所有VIEW可查詢

資料庫已更改。

ORACLE 查詢時 VIEW優先，然後是 synonym

SQL> conn xh/a831115
已連線。
SQL> create table t1 as select * from user_users;

表已建立。

SQL> create view v$t1 as select * from t1;

檢視已建立。

SQL> create view v_$t1 as select * from v$t1;

檢視已建立。

SQL> create public synonym v$t1 for v_$t1;

同義詞已建立。

SQL> conn / as sysdba
已連線。
SQL> create view v$t1 as select username from user_users ;

檢視已建立。

SQL> desc v$t1;
名稱是否為空? 型別
----------------------------------------- -------- -------------------------

USERNAME NOT NULL VARCHAR2(30)

SQL> drop view v$t1;~~~~~~~刪除這個VIEW

檢視已刪除。

SQL> desc v$t1;再查詢是 SYNONYM
名稱是否為空? 型別
----------------------------------------- -------- ----------------------------

USERNAME                                  NOT NULL VARCHAR2(30)
USER_ID                                   NOT NULL NUMBER
ACCOUNT_STATUS                            NOT NULL VARCHAR2(32)
LOCK_DATE                                          DATE
EXPIRY_DATE                                        DATE
DEFAULT_TABLESPACE                        NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
CREATED                                   NOT NULL DATE
INITIAL_RSRC_CONSUMER_GROUP                        VARCHAR2(30)
EXTERNAL_NAME                                      VARCHAR2(4000)

實驗看v$parameter

SQL> desc v$fixed_view_definition
名稱是否為空? 型別
----------------------------------------- -------- ---------------------

VIEW_NAME VARCHAR2(30) 檢視名
VIEW_DEFINITION VARCHAR2(4000) 檢視定義
SQL> select view_definition from v$fixed_view_definition where view_name='V$PARA
METER';

VIEW_DEFINITION
--------------------------------------------------------------------------------

select NUM , NAME , TYPE , VALUE , DISPLAY_VALUE, ISDEFAULT , ISSES_MODIFIABLE
, ISSYS_MODIFIABLE , ISINSTANCE_MODIFIABLE, ISMODIFIED , ISADJUSTED , ISDEPRECAT

ED, DESCRIPTION, UPDATE_COMMENT, HASH from GV$PARAMETER where inst_id = USERENV

('Instance') ~~~~~~~~~~~~~~~~~~~基於gv$parameter

SQL> select view_definition from v$fixed_view_definition where view_name='GV$PAR
AMETER';

VIEW_DEFINITION
--------------------------------------------------------------------------------

select x.inst_id,x.indx+1,ksppinm,ksppity,ksppstvl, ksppstdvl, ksppstdf, decode

(bitand(ksppiflg/256,1),1,'TRUE','FALSE'), decode(bitand(ksppiflg/65536,3),1,'I

MMEDIATE',2,'DEFERRED', 3,'IMMEDIATE','FALSE'),

decode(bitand(ksppiflg,4),4,'FALSE', decod

e(bitand(ksppiflg/65536,3), 0, 'FALSE', 'TRUE')), decode(bitand(ksppstvf,7),

1,'MODIFIED',4,'SYSTEM_MOD','FALSE'), decode(bitand(ksppstvf,2),2,'TRUE','FALSE

'), decode(bitand(ksppilrmflg/64, 1), 1, 'TRUE', 'FALSE'), ksppdesc, ksppstcmn

t, ksppihash from x$ksppi x, x$ksppcv y where (x.indx = y.indx) and ((translat

e(ksppinm,'_','#') not like '##%') and ((translate(ksppinm,'_','#') not like
'#%') or (ksppstdf = 'FALSE') or (bitand(ksppstvf,5) > 0)))

基於

x$ksppi x, x$ksppcv y 所有引數都在這個2個VIEW中包含隱藏引數

V$ VIEW 不能直接授予 USER （SYS 除外） ,可以通過v_$這個檢視基於（v$）授予USER，USER 查詢時通過 SYNOYNM（對V_$建立）

SQL> grant select on v$instance to xh;
grant select on v$instance to xh
*
第 1 行出現錯誤:
ORA-02030: 只能從固定的表/檢視查詢

SQL> desc sys.v$parameter;（SYS 是直接先訪問 VIEW）可以看到普通USER 無法訪問V$ VIEW
ERROR:
ORA-04043: 物件 sys.v$parameter 不存在

SQL> desc v$parameter; 訪問的是基於V_$建立的SYNONYM
名稱是否為空? 型別
----------------------------------------- -------- ----------------------------

NUM                                                NUMBER
NAME                                               VARCHAR2(80)
TYPE                                               NUMBER
VALUE                                              VARCHAR2(512)
DISPLAY_VALUE                                      VARCHAR2(512)
ISDEFAULT                                          VARCHAR2(9)
ISSES_MODIFIABLE                                   VARCHAR2(5)
ISSYS_MODIFIABLE                                   VARCHAR2(9)
ISINSTANCE_MODIFIABLE                              VARCHAR2(5)
ISMODIFIED                                         VARCHAR2(10)
ISADJUSTED                                         VARCHAR2(5)
ISDEPRECATED                                       VARCHAR2(5)
DESCRIPTION                                        VARCHAR2(255)
UPDATE_COMMENT                                     VARCHAR2(255)
HASH                                               NUMBER

看oracle訪問過程

SQL> alter session set events '10046 trace name context forever,level 12';用10046跟蹤

會話已更改。

SQL> select count(*) from v$parameter;

COUNT(*)
----------
263

select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null

and linkname is null and subname is null
END OF STMT
PARSE #1:c=0,e=637,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=9148878891
BINDS #1:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=07ad56dc bln=22 avl=02 flg=05
value=61
Bind#1
acdty=01 mxl=32(11) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=01 csi=852 siz=32 ff=0
kxsbbbfp=07ad56b0 bln=32 avl=11 flg=05
value="V$PARAMETER"
Bind#2
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=07ad568c bln=24 avl=02 flg=05
value=1

SQL> select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spa
re2 from obj$ where owner#=61 and name='V$PARAMETER' and namespace=1;

未選定行~~~輸入 61,v$parameter ，1 沒記錄 XH SCHEMA下沒有這個OBJ，所以為空接著判斷驗證SYNONYM,假如OBJ屬於查詢的SCHEMA的話 oracle
可以查到以下資訊看到物件型別，按表>view>synonym 定位判斷
type :1 = INDEX, 2 = TABLE, 3 = CLUSTER, 4 = VIEW, 5 = SYNONYM, 6 = SEQUENCE

SQL> select username from dba_users where user_id=61;(OWNER#)

USERNAME
------------------------------
XH
SQL> select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spa
re2 from obj$ where owner#=1 and name='V$PARAMETER' and namespace=1;

      OBJ#      TYPE# CTIME          MTIME          STIME              STATUS
---------- ---------- -------------- -------------- -------------- ----------
DATAOBJ#      FLAGS OID$                                 SPARE1     SPARE2
---------- ---------- -------------------------------- ---------- ----------
      1097          5 30-8月 -05     30-8月 -05     30-8月 -05              1
                    0                                           6      65535

繼續輸出
select node,owner,name from syn$ where obj#=:1
END OF STMT
PARSE #3:c=31250,e=132154,p=0,cr=147,cu=0,mis=1,r=0,dep=1,og=4,tim=9149088970
BINDS #3:
kkscoacd
Bind#0
acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=07a83a2c bln=22 avl=03 flg=05
value=1097

SQL> select object_id,object_type,owner from dba_objects where object_id=1097;

OBJECT_ID OBJECT_TYPE OWNER
---------- ------------------- ------------------------------
1097 SYNONYM PUBLIC~~~~~~~~~~~~~~~~~~~~~~~~~~是個同譯詞屬於公有(表和，VIEW 沒查到查詢公有SYNONYM)

SQL> select node,owner,name from syn$ where obj#=1097;

NODE
--------------------------------------------------------------------------------

OWNER NAME
------------------------------ ------------------------------

SYS V_$PARAMETER~~~~~~~ 是V_$PARAMETER的同譯詞屬於SYS SCHEMA

select text from view$ where rowid=:1 查詢view獲得定義VIEW 的SQLTEXT
END OF STMT

BINDS #1:
kkscoacd
Bind#0
acdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
acflg=18 fl2=0001 frm=00 csi=00 siz=16 ff=0
kxsbbbfp=07a8bd94 bln=16 avl=16 flg=05
value=000001CD.001D.0001

SQL> select obj# from view$ where dbms_rowid.rowid_to_restricted(rowid,0)='00000
1CD.001D.0001';

OBJ#
----------~~~~~檢視obj 為1096
1096
SQL> select object_id,object_type,owner,object_name from dba_objects where objec
t_id=1096;

OBJECT_ID OBJECT_TYPE OWNER
---------- ------------------- ------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------

1096 VIEW SYS
V_$PARAMETER

查詢SYS V_$PARAMETER 這個VIEW 定義的SQLTXT

SQL> select text from view$ where dbms_rowid.rowid_to_restricted(rowid,0)='00000
1CD.001D.0001';

TEXT
--------------------------------------------------------------------------------

select "NUM","NAME","TYPE","VALUE","DISPLAY_VALUE","ISDEFAULT","ISSES_MODIFIABLE ....FROM V$PARAMETER（基於x$建立的view）

~~~~~~~~~
SQL>

順序：
parse for object t
if (table t OR VIEW t) 先查表 or view 是否存在
RETURN
elseif (synonym t)~~~~~不存在表or view 查私有SYNONYM
return
elseif(public synonym t) 不存在私有synonym 查公有synonym
return
else
signal 0ra-00942(TABLE OR VIEW DOES NOT EXIST)~~~~~~~~~都沒有報錯

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12020513/viewspace-615502/，如需轉載，請註明出處，否則將追究法律責任。

oracle實驗記錄 (oracle 資料字典)

相關文章