04 2021 档案
摘要:官网:http://yck1509.github.io/ConfuserEx/ 下载地址:https://github.com/yck1509/ConfuserEx/releases 使用参考:https://www.cnblogs.com/zhangzhi19861216/p/3937434.ht
阅读全文
摘要:using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.
阅读全文
摘要:解决办法 使用binary关键字,此时就能区分大小写了 SELECT * FROM `tb_test` WHERE BINARY COL_1='abc'
阅读全文
摘要:记录一下 SELECT UPPER(F.TABLESPACE_NAME) "表空间名", D.TOT_GROOTTE_MB "表空间大小(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)", TO_CHAR(ROUND((D.TOT_GROOTTE_MB
阅读全文
摘要:原始数据: 方式一: select t_name, sum(decode(t_item, 'item1', t_num, 0)) item1, sum(decode(t_item, 'item2', t_num, 0)) item2, sum(decode(t_item, 'item3', t_nu
阅读全文
摘要:导出数据 SQL> conn / as sysdba Connected. SQL> create directory lxw_dir as '/home/oracle'; Directory created. SQL> grant write,read on directory lxw_dir t
阅读全文
摘要:alter system set open_links=0 sid ='*' scope=spfile; System altered. alter system set open_links_per_instance=0 sid ='*' scope=spfile; System altered.
阅读全文
摘要:PROCEDURE proc_test(p_id IN NUMBER, v_cur OUT SYS_REFCURSOR, p_result_code OUT NUMBER, p_result_message OUT VARCHAR2) AS p_flag NUMBER; p_row frm_tabl
阅读全文