Oracle常用(学习笔记，不定时更新……)

--REGEXP_SUBSTR函数，也可用于行转列

SELECT REGEXP_SUBSTR('1,24,5,3,3', '[^,]+', 1, LEVEL) AS STR FROM dual
CONNECT BY LEVEL <= LENGTH('1,24,5,3,3') - LENGTH(REGEXP_REPLACE('1,24,5,3,3', ','))+1; 

--同义词，和视图的功能类似。就是一种映射关系

普通用法：
CREATE [OR REPLACE] [PUBLIC] SYNONYM [ schema.] 同义词名称 FOR [ schema.] object [ @dblink ];
--专有（私有）同义词：
CREATE SYNONYM SYSN_TEST FOR TEST;
--公共同义词：
CREATE PUBLIC SYNONYM PUBLIC_TEST FOR TEST;

SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME IN ( 'SYSN_TEST','PUBLIC_TEST') --查询指定

CREATE PUBLIC SYNONYM TEST FOR REF.REF_WGG_STUDENT; --创建公有

SELECT * FROM TEST; --查询