MIS_YU的博客

今天oracle从11g升级到12c，突然发现原来的wmsys.wm_concat（）函数不能使用了，查了而之后可以使用listagg代替。参考：https://blog.youkuaiyun.com/sinat_36257389/article/details/81004843使用 listagg() WITHIN GROUP () 将多行合并成一行(比较常用)select listagg...

慢慢积累，会不断更新当某个表建立多个索引，查询想强制走某个索引的时候，加一个hint，可以强制走这个索引/*+ index(索引名) */

具体使用参见https://blog.youkuaiyun.com/qq_25221835/article/details/82762416 select policyno,zyempno,row_number() over(partition by policyno order by zytime desc) rank from dy_zywater

oracle查询索引SELECT b.uniqueness, a.index_name, a.table_name, a.column_name FROM all_ind_columns a, all_indexes b WHERE a.index_name=b.index_name AND a.table_name = upper('&tab_name') ORDER...

oracle 存储过程不能编译– （编译的同时正在访问所导致的）1.SELECT * FROM VDBOBJECTCACHEWHEREname=′NCCMMEDICALUSERSTATS2′ANDLOCKS!=′0′;2.selectSIDfromVDBOBJECTCACHEWHEREname=′NCCMMEDICALUSERSTATS2′ANDLOCKS!=′0′;2.selectSIDfr...

SELECT a.tablespace_name "表空间名", total/1024/1024 "表空间大小单位M", free/1024/1024 "表空间剩余大小单位M", (total - free)/1024/1024 "表空间使用大小单位M", Round((total - free) / total, 4) * 100 "使用...

MERGE INTO table_name alias1 USING (table|view|sub_query) alias2ON (join condition) WHEN MATCHED THEN UPDATE table_name SET col1 = col_val1, col2 = col_val2 WHEN NOT MATCHED ...

[oracle@WWJD01 ~]$ sqlplus / as sysdbaSQL> startupORA-27104: system-defined limits for shared memory was misconfiguredSQL>alert log2018-09-21T15:05:16.542629+08:00Starting ORACLE instan...