Oracle不常见函数

在看官方文档的时候发现了几个函数 记录一下

SCOTT@PROD>select to_char(current_timestamp,'YYYY-MM-DD HH24:MI:SSxFF TZH:TZM') from dual;

TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-D'
------------------------------------
2018-12-07 20:30:53.103065 +08:00


#返回最大的那个参数,参数类型是由第一个表达式的类型决定的
SCOTT@PROD>select greatest(1,'8',2.3,0) from dual;

GREATEST(1,'8',2.3,0)
---------------------
                    8


create or replace type ename as table of varchar2(400);
/

SCOTT@PROD>SELECT CAST(COLLECT(ename ORDER BY empno) AS ename) "员工姓名集合" FROM emp;

员工姓名集合
----------------------------------------------------------------------------------------------------
ENAME('SMITH', 'ALLEN', 'WARD', 'JONES', 'MARTIN', 'BLAKE', 'CLARK', 'KING', 'TURNER', 'ADAMS', 'JAMES', 'FORD', 'MILLER')