随笔分类 - Oracle_SQL_相关
记录日程使用sql过程中的知识
摘要：今天做开发,需求是 /** * 1.先获取查询lraccount账单表, * 2.查询数据预估表lrlistCollect表, * 3.二者相减存到lrpreAdjust账单调整表 * 4.发送邮件 */ 初步就像写的逻辑是 String sql01="select * from Lraccount
阅读全文
摘要：select * FROM LPEdorItem a, LCCont b, LPEdorApp c WHERE a.edoracceptno = c.edoracceptno and a.ContNo = b.ContNo and b.appntno = '0000235356' AND b.con
阅读全文
摘要：select Code, CodeName, CodeAlias, ComCode, OtherSign from ldcode where codetype = 'edorapptype' and code <> (case when (select 1 from lccont b where b
阅读全文
摘要：SELECT * FROM LACOMMISION WHERE MANAGECOM LIKE'8694%' AND STATE='1' AND EXISTS(SELECT 1 FROM laagent WHERE LACOMMISION.AGENTCODE=AGENTCODE) 先说exists 比
阅读全文
摘要：var strsql=" select e.* from es_doc_main e where 1=1" +" and e.doccode='"+prtNo+"' and e.subtype <> '1022' and e.busstype='TB' order by subtype "; //s
阅读全文
摘要：select CustomerNo, Name, Sex, Birthday, IDType, IDNo, validityday, case (null ) when '1' then '高级VIP' when '2' then '顶级VIP' else '一般客户' end from LDPer
阅读全文
摘要：创建表 create table users(id int,name varchar2(20),sex number); insert into users(id,name) values(1,'张一'); insert into users(id,name,sex) values(2,'张二',1
阅读全文
摘要：step1:通过cmd打开命令提示符, sqlplus /nolog step2:输入conn /as sysdba step3:输入alter user system identified by 新密码; 输出结果:用户已更改 system 默认密码:manager
阅读全文
