04 2017 档案
摘要：declare v_cnt number; V_SQL VARCHAR2 (500) := '';begin select count(*) into v_cnt from dual where exists(SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NA
阅读全文
摘要：="insert into tb_fdn_deviceaccount (zdmc,czmc,sbbh,sbmc,SZCS,SBFLMC,SBLXMC,SBGG,SBYZ,SBJZ,SBXH,SBZL,ZZDW,ZZNY,PPMC,GZYL,EDDY,SBGL,SYNY,SYR,JSZTMC,SBBD
阅读全文
摘要：ceil和floor函数在一些业务数据的时候，有时还是很有用的。 ceil(n) 取大于等于数值n的最小整数； floor(n)取小于等于数值n的最大整数 如下例子 SQL> select ceil(9.5) from dual; CEIL(9.5) 10 SQL> select floor(9.5
阅读全文
摘要：update tb_fdn_deviceaccount set czMC =replace(czMC,'站','') where zdmc in ('大连站','沈阳北站');delete from tb_fdn_deviceaccount where zdmc is null;update tb_
阅读全文
摘要：--编号declare v_cnt number; V_SQL VARCHAR2 (500) := '';begin select count(*) into v_cnt from dual where exists(SELECT * FROM USER_TAB_COLUMNS WHERE TABL
阅读全文
摘要：declare v_cnt number; V_SQL VARCHAR2 (500) := '';begin select count(*) into v_cnt from dual where exists(SELECT * FROM user_tables WHERE TABLE_NAME =
阅读全文
摘要：using System;using System.Collections.Generic;using System.IO;using System.Linq;using System.Runtime.Remoting.Contexts;using System.Web;using System.W
阅读全文
摘要：/^[+-]?\d+(\.\d+)?$|^$|^(\d+|\-){7,}$/
阅读全文
摘要：SELECT w.ZDBH,w.HEATINGANDAIRCONDITIONERID, w.ZDMC, w.CZBH, w.CZMC, w.CNXS, w.ND, w.KTJF, w.KTJFMJ, w.KTZY, w.KTCS, w.KTJ, h.hMJ HCOUNT, a.hmj KCOUNTF
阅读全文
摘要：select train_code,count(1) from tb_ask_trainbodyroadtrain group by train_code having count(1) >1
阅读全文
摘要：using KYZWeb.Common;using Liger.Data;//using Microsoft.Office.Interop.Excel;using System;using System.Collections.Generic;using System.Data;using Syst
阅读全文
摘要：字体属性：(font)大小 {font-size: x-large;}(特大) xx-small;(极小) 一般中文用不到，只要用数值就可以，单位：PX、PD样式 {font-style: oblique;}(偏斜体) italic;(斜体) normal;(正常)行高 {line-height:
阅读全文