3,494
社区成员




SQL> select ename from emp;
ENAME
----------
SMITH1
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
JAMES
FORD
MILLER
14 rows selected
SQL> update emp set ename=substr(ename,1,4)||' '||substr(ename,5);
14 rows updated
SQL> commit;
Commit complete
SQL> select ename from emp;
ENAME
----------
SMIT H1
ALLE N
WARD
JONE S
MART IN
BLAK E
CLAR K
SCOT T
KING
TURN ER
ADAM S
JAME S
FORD
MILL ER
14 rows selected
SQL>