王威振的博客

第一步：explain plan for SELECT * from table //执行计划(此处的表查询由于隐私，所以没拿出来)第二步：select * from table(dbms_xplan.display)//查询分析select * from user_indexes where table_name= 'DC_COMP_STAFF';//查看某个表的索引情况crea...

注：to_char()函数的使用，是因为查询的数据乱码（数据集的问题），用to_char可以解决oracle 12c不支持wm_concat，需要自己定义select t.*,(select wm_concat(to_char(s.data_value)) from dev_common s where instr(t.attach_label_code,s.id)>0) name...

SELECT sid, serial#, username, osuser FROM v$session where sid in (select session_id from v$locked_object);ALTER SYSTEM KILL SESSION '135,2373';//sid, serial#

微信扫一扫关注个公众号。谢谢各位查询最近删除的操作SELECT * FROM RECYCLEBIN ORDER BY DROPTIME DESC恢复删除的表FLASHBACK TABLE tableName TO BEFORE DROP;...

with tmp as ( select t.*, length(ATTACH_LABEL_CODE)-length(regexp_replace(ATTACH_LABEL_CODE, ',', ''))+1 len ...

SELECT 'alter system kill session '''||sid||','||serial#||''';' from v$session where sql_id in(select sql_id from v$session where paddr in( select addr from v$process where spid in(sel...

微信扫一扫关注个公众号。谢谢各位1.控制面板-所有控制面板项-管理工具-ODBC 数据源2.切记如果是外网服务，ip server 要填写外网地址3.找到oracle安装目录，找到D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN目录下的listener.ora4.然后再同目录下找到tnsna...

select regexp_substr('aaa,bbb,ccc,ddd,eee','[^,]+',1,LEVEL,'i') from dualCONNECT BY LEVEL <= LENGTH('aaa,bbb,ccc,ddd,eee') - LENGTH(REGEXP_REPLACE('aaa,bbb,ccc,ddd,eee', ',', '')) + 1REGEXP...

SELECT DISTINCT *FROM (SELECT comments AS "Name", a.column_name "Code", a.DATA_TYPE AS "DataType", b.comments AS "Comment", DECODE( c.column_name, NULL, 'FALSE', 'TRUE' ...

CHAR(9)=&gt;水平制表符char(10)=&gt;换行建char(13)=&gt;回车键具体用法如下： UPDATE tb_doctor SET title = REPLACE(REPLACE(title, CHR(9), ''), CHR(13), '');========&gt;mysql中CHR改为CHAR用replace把相应的水平制表、回车键替换为空字符串...