我也觉得好奇怪啊 ,没有效果啊
SQL> create table test1 (id number);
Table created.
SQL> insert into test1 values(1);
1 row created.
SQL> insert into test1 values(2);
1 row created.
SQL> insert into test1 values(3);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test1 a where a.id(+)=3;
ID
----------
3
SQL> update test1 set id = 4 where id=3;
1 row updated.
SQL> commit;
Commit complete.
SQL> select * from test1;
ID
----------
1
2
4
SQL> select * from test1 a where a.id(+)=3;
no rows selected
SQL> select * from test1 a where a.id(+)='3';
no rows selected