1.字符串拼接 (使用 || )
SELECT 字串|| 字串 FROM TABLE
2.时间格式化
SELECT TO_CHAR(时间,'yyyy-MM-dd') FROM TABLE
3.查询当前时间
SELECT SYSDATE FROM TABLE
4.存在更新,不存在插入
BEGIN
UPDATE TABLE SET COLUMN = VALUE WHERE CONDITION;
IF SQL % ROWCOUNT = 0 THEN
INSERT INTO TABLE( COLUMN ... ) VALUES ( VALUE ...);
END IF;
END;
5.逗号拼接多个结果
SELECT listagg ( column, ',' ) WITHIN GROUP ( ORDER BY column) FROM table WHERE condition
6.listagg 去重
select regexp_replace(listagg(column, ',') within group(order by column),'([^,]+)(,\1)+','\1') as column from table where condition
7.空值判断 NVL
SELECT NVL(COLUMN1,COLUMN2) FROM TABLE WHERE CONDITION