Oracle:转换函数

1.ASCIISTR()
ASCIISTR(x):将x转换为ASCII字符串。

select asciistr('abc') from dual;

ASCIISTR('ABC')
------------------
abc

2.BIN_TO_NUM()
BIN_TO_NUM():将二进制数x转换为NUMBER类型

select BIN_TO_NUM(1,0,1) from dual;
BIN_TO_NUM(1,0,1)
-----------------
5

3.CAST()
CAST(x AS type):将x转换为由type指定的兼容数据库类型。

select CAST(12345.67 AS VARCHAR2(10)) from dual;

CAST(12345.67ASVARCHAR2(10))
-----------
12345.67

4.CHARTOROWID()
CHARTOROWID(x):将x转换为ROWID。
5.COMPOSE()
COMPOSE(x):将x转换为Unicode字符串。
6.CONVERT()
CONVERT(x, source_char_set, dest_char_set):将x从source