--获取服务器 IP 机器名(UTL_INADDR)
select UTL_INADDR.GET_HOST_ADDRESS IP, UTL_INADDR.GET_HOST_NAME MSNAME from DUAL t;
--将多列合并成一列(拼接)
SELECT wmsys.wm_concat (T.COLUMN_NAME) as result
FROM ALL_TAB_COLUMNS T
WHERE TABLE_NAME = '表名'
--全角转换成半角
SELECT To_Single_Byte('21,500円(消費税別)US$@¥55/pc') FROM dual;
-- RPAD和LPAD(粘贴字符)
SQL>select RPAD(City,35,'.'),temperature from weather;
RPAD(City,35,'.') temperature
-------------------------- ----------------
CLEVELAND...... 85
LOS ANGELES.. 81
.........................
(即不够35个字符用'.'填满)
-- TRIM不止是截空格哦
/*
TRIM( [<leading>] <trailing> FROM <trim_char> )
例子:将下面字符串中的前面和后面的‘0‘字符都去掉:
*/
SELECT TRIM (0 FROM 0009872348900) "TRIM Example" FROM DUAL;
TRIM example
--------------------------------
98723489
-- INITCAP 第一个字母转换成大写
SQL> select initcap('simth') upp from dual;
UPP
-----
Simth