Debugs

摘要： public static void PrintPersons() { //准备数据 DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("ID", typeof(int))); dt.Columns.Add(new DataC 阅读全文

摘要： CREATE OR REPLACE TRIGGER trg_quote_otherArea_to_list before insert or delete or update of modify_date on tab_quote_other_area for each rowdeclare int 阅读全文

摘要： case when里的like功能 假如要用到case when又要用到like这样的功能，即如果字符串包含‘语文’就怎么怎么样，包含‘数学’就怎么怎么样，包含‘英语’就怎么怎么样，like是用于where中的，放在case when里面是无效的，可以用instr()这个函数来查找这些字符出现的位置 阅读全文

摘要： with temp as(select FILE_PATH as text from TAB_CONTRACT)select substr(text,instr(text,',',1,rn)+1,instr(text,',',1,rn+1)-instr(text,',',1,rn)-1) text 阅读全文

摘要： CREATE OR REPLACE TRIGGER TAB_AMERCE_balance_new before insert or delete or update of BL_AUDITED ON TAB_AMERCE for each rowdeclare -- local variables 阅读全文

摘要： CREATE OR REPLACE TRIGGER trg_base_authority_insert before insert ON T_BASE_AUTHORITY for each rowdeclare integrity_error exception; errno integer; er 阅读全文

摘要： public class SharpZip { /// <summary> /// 压缩 /// </summary> /// <param name="param"></param> /// <returns></returns> public string Compress(string par 阅读全文

摘要： //转换大写 private string Change(double Digital) { //将小写金额转换成大写金额 String[] MyScale = { "分", "角", "元", "拾", "佰", "仟", "万", "拾", "佰", "仟", "亿", "拾", "佰", "仟 阅读全文

摘要： select T.BILL_CODE,t.SCAN_TYPE,t.PIECE,SCAN_SITE,SCAN_MAN, row_number() over(partition by t.bill_code order by t.scan_date desc) AS R from tab_scan_se 阅读全文

摘要： select owner,object_name,object_type,status from dba_objects where object_name = 'LT_EXPORT_PKG';如果有失效对象在SQLPLUS中执行SQL> @?/rdbms/admin/utlrp 重新编译一下再试试看如果还是不行, 最终解决方案,重建该对象:SQL> @?/rdbms/admin/owmins... 阅读全文