디비랑[dɪ'bɪraŋ]

/********************************************************************************************
-- Title : [10g] 시노님 관리 -ver.dbrang
-- Reference : dbrang.com
-- Key word : 동의어 synonym
********************************************************************************************/
-- 테이블 생성
CREATE TABLE scott.tbl77
( a NUMBER NOT NULL PRIMARY KEY
, b VARCHAR(2) NOT NULL
) TABLESPACE users;

INSERT INTO scott.tbl77 VALUES (1, '11');
COMMIT;

-- 읽기
SELECT * FROM scott.tbl77;

-- 시노님 생성
CREATE PUBLIC SYNONYM s_tbl77
FOR scott.tbl77;

-- 시노님 생성 확인
SELECT *
FROM dba_synonyms
WHERE owner IN ('PUBLIC')
AND synonym_name = 'S_TBL77';

-- 시노님 사용
SELECT * FROM s_tbl77;

INSERT INTO s_tbl77 VALUES (2, '22');
COMMIT;

SELECT * FROM s_tbl77;

-- 시노님 삭제
DROP PUBLIC SYNONYM s_tbl77;