|
SCOTT@bi>select * from dept2;
no rows selected
Elapsed: 00:00:00.04
SCOTT@bi>insert into dept2 select 1,'abs&r3','rr' from dual;
Enter value for r3: 1
old 1: insert into dept2 select 1,'abs&r3','rr' from dual
new 1: insert into dept2 select 1,'abs1','rr' from dual
1 row created.
Elapsed: 00:00:00.04
SCOTT@bi>select * from dept2;
DEPTNO DNAME LOC
---------- -------------- -------------
1 abs1 rr
Elapsed: 00:00:00.07
SCOTT@bi>set define off;
SCOTT@bi>insert into dept2 select 1,'abs&r3','rr' from dual;
1 row created.
Elapsed: 00:00:00.04
SCOTT@bi>select * from dept2;
DEPTNO DNAME LOC
---------- -------------- -------------
1 abs1 rr
1 abs&r3 rr
Elapsed: 00:00:00.09
SCOTT@bi> |
|