Oracle
Cheney94
这个作者很懒,什么都没留下…
展开
-
Oracle 之 分割字段以Table显示
with t1 as(select '张三' 姓名, '唱歌、跳舞' 爱好 from dualunion allselect '李四' 姓名,'吃饭、睡觉、打张三' 爱好 from dualselect 姓名,level,regexp_substr(爱好,['[^、]',1,level) 爱好From t1connect by level <= regexp_count (爱好,'[^、]+')and prior 姓名=姓名and prior dbms_random.value is.原创 2022-05-05 10:10:22 · 538 阅读 · 0 评论 -
Oracle 查杀会话进程
查询SELECT sess.sid,sess.serial#,lo.oracle_ usemame,lo.os_user_name,ao.object_name,lo.locked modeFROM v$locked_object lo, dba_objects ao, v$session sessWHERE ao.object _id = lo.object_idAND lo.session id= sess.sidAND ao.OBJECT_NAME = 'TABLE_NAME'原创 2022-04-21 09:27:59 · 1466 阅读 · 0 评论 -
Oracle 定位Blob字段数据
因数据存储在Blob字段中,想要对其检索查询SELECT REQUEST_XML, RESPONSE_XML, A.*FROM OWNER.TABLE aWHERE ADD_DATE > TO_DATE ('20210930 180001','YYYYMMDD HHZ4MISS')AND ADD_DATE < TO_DATE ('20210930 180001', 'YYYYMMDD HHZ4MISS')AND API_NAME LIKE 'Ra/repair update'AN原创 2022-04-21 09:18:57 · 585 阅读 · 0 评论