举例说明: --------------------------------------------------------------- SQL> CREATE TABLE TEST3 ( ID NUMBER (2) PRIMARY KEY, NAME VARCHAR2 (20));
SQL> show define; define "&" (hex 26)
SQL> insert into test3 values(1,''''sgs&a&n''''); Enter value for a: abc Enter value for n: 456 old 1: insert into test3 values(1,''''sgs&a&n'''') new 1: insert into test3 values(1,''''sgsabc456'''')
1 row created.
SQL> commit;
Commit complete.
SQL> set define off;
SQL> insert into test3 values(2,''''sgs&a&n'''');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test3;
ID NAME -- -------------------- 1 sgsabc456 2 sgs&a&n
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
