SQL> insert into employees(emp_num, emp_firstname,
2
emp_name, emp_email)
3select emp_num,
4 emp_firstname,
5 emp_name,
6 decode(rn, 1, emp_email,
7
substr(emp_email,
8
1, 12 - length(ltrim(to_char(rn))))
9
|| ltrim(to_char(rn)))
10from (select emp_num,
11
emp_firstname,
12
emp_name,
13
substr(substr(emp_firstname, 1, 1)
14
||translate(emp_name, ' ''', '__'), 1, 12)
15
emp_email,
16
row_number()
17
over (partition by
18
substr(substr(emp_firstname, 1, 1)
19
||translate(emp_name,' ''','__'),1,12)
20
order by emp_num) rn
21from employees_old)
22/
红色的那段,请帮忙看看
|