set define off --这个是sqlplus的命令,其他工具可能没有这个命令 SQL> set define off; SQL> insert into emp(empno,ename) values(1111,'&xxx');已创建 1 行。SQL> select * from emp where empno=1111; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- -------------- ---------- ---------- ---------- 1111 &xxx
SQL> insert into emp(empno,ename) values(1111,chr(38)||'xx');已创建 1 行。SQL> select * from emp where empno=1111; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ---------- ----------
1111 &xx
2 (a varchar2(10));
Table createdSQL> insert into testtt
2 select chr(38)||'123' from dual
3 ;
1 row inserted
SQL> select * from testtt;
A
----------
&123
SQL>
SQL> set define off
SQL> insert into testtt values('&1233');
1 row inserted
SQL> select * from testtt;
A
----------
&1233
SQL>
command窗口怎么打开,嘿嘿。
SQL> set define off;
SQL> insert into emp(empno,ename) values(1111,'&xxx');已创建 1 行。SQL> select * from emp where empno=1111; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ---------- ----------
1111 &xxx