- 论坛徽章:
- 0
|
数据如下:
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
然后将数字和字母分离
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
请问这一句translate(data,'0123456789' || data, '0123456789')是什么意思?请详细解释下过程。 |
|