震惊!!!Oracle SQL语句中竟然支持中文括号??
Oracle中文指令指日可待[狗头]。
看看下边的结果吧(看图片的会比较明显,里边是中文的括号)。
16:49:20 ZKM@zkm(413)> merge into (select * from t1 where stu_id = '0001') tt1
16:49:21 2 using (select * from t2) tt2
16:49:21 3 on (tt1.stu_id = tt2.stu_id)
16:49:21 4 when matched then
16:49:21 5 update set tt1.credit = tt2.credit ;
1 row merged.
Elapsed: 00:00:00.00
16:49:25 ZKM@zkm(413)> select sql_id,prev_sql_id from v$session where sid=413;
SQL_ID PREV_SQL_ID
--------------------------------------- ---------------------------------------
3gp8t5837gkf1 ftfxakkrv28up
Elapsed: 00:00:00.00
16:49:46 ZKM@zkm(413)> !ora sqltext ftfxakkrv28up
Session altered.
Elapsed: 00:00:00.00
SQL_FULLTEXT
-----------------------------------------------------------------
merge into (select * from t1 where stu_id = '0001') tt1
using (select * from t2) tt2
on (tt1.stu_id = tt2.stu_id)
when matched then
update set tt1.credit = tt2.credit
Elapsed: 00:00:00.00
16:52:51 ZKM@zkm(413)> select (1+2) from dual;
(1+2)
----------
3
Elapsed: 00:00:00.00
16:52:55 ZKM@zkm(413)> select (1+2) from dual;
(1+2)
----------
3
Elapsed: 00:00:00.00
除了震惊一下,没啥用[狗头]。