我隻能做到這樣
SQL> SELECT * FROM BAO_TEMP
2 / ID NAME
---------- ----------
1 BAO目前歷時: 00:00:00.15SQL> DECLARE
2 T BAO_TEMP%ROWTYPE;
3 BEGIN
4 T.NAME := 'LONG';
5 INSERT INTO BAO_TEMP VALUES (T.ID,T.NAME);
6 COMMIT;
7 END;
8 /PL/SQL 程序順利完成目前歷時: 00:00:00.63
SQL> SELECT * FROM BAO_TEMP
2 / ID NAME
---------- ----------
1 BAO
LONG目前歷時: 00:00:00.16
SQL> SELECT * FROM BAO_TEMP
2 / ID NAME
---------- ----------
1 BAO目前歷時: 00:00:00.15SQL> DECLARE
2 T BAO_TEMP%ROWTYPE;
3 BEGIN
4 T.NAME := 'LONG';
5 INSERT INTO BAO_TEMP VALUES (T.ID,T.NAME);
6 COMMIT;
7 END;
8 /PL/SQL 程序順利完成目前歷時: 00:00:00.63
SQL> SELECT * FROM BAO_TEMP
2 / ID NAME
---------- ----------
1 BAO
LONG目前歷時: 00:00:00.16
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货