亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: translate函數(shù)問(wèn)題求教 [打印本頁(yè)]

作者: jamesapple321 時(shí)間: 2016-07-17 10:46
標(biāo)題: translate函數(shù)問(wèn)題求教
數(shù)據(jù)如下：
SQL> create table dept2 as
  2  select dname || deptno as data from dept;

Table created.

SQL> select data from dept2;

DATA
-------------------------
ACCOUNTING10
RESEARCH20
SALES30
OPERATIONS40

然后將數(shù)字和字母分離
SQL> select translate(data,'a0123456789','a') dname,
  2  translate(data,'0123456789' || data, '0123456789') deptno
  3  from dept2;

DNAME       DEPTNO
-------------------- --------------------
ACCOUNTING       10
RESEARCH       20
SALES       30
OPERATIONS       40

請(qǐng)問(wèn)這一句translate(data,'0123456789' || data, '0123456789')是什么意思？請(qǐng)?jiān)敿?xì)解釋下過(guò)程。

歡迎光臨 Chinaunix (http://www.72891.cn/)