Oracle
Java超神之路
这个作者很懒,什么都没留下…
展开
-
oracle - for in loop 循环更新
在这BEGIN FOR r IN ( SELECT A .* FROM SYS_STATIONS A WHERE a.STATION_LEVEL='3' and a.PARENT_ID='734B4980-DA31-4A80-AFD8-BEB7AEB0D2E2' and a.STATION_TYPE='0' ) loopUPDATE SYS_STATIONSSET OLD_STATION_ID = r.STATION_IDWH原创 2022-01-07 15:24:12 · 1998 阅读 · 0 评论 -
oracle--查询锁表情况
–以下几个为相关表SELECT * FROM vlock;SELECT∗FROMvlock;SELECT * FROM vlock;SELECT∗FROMvsqlarea;SELECT * FROM vsession;SELECT∗FROMvsession;SELECT * FROM vsession;SELECT∗FROMvprocess ;SELECT * FROM vlockedobject;SELECT∗FROMallobjects;SELECT∗FROMvlocked_object;S原创 2022-01-10 15:48:38 · 312 阅读 · 0 评论