第一份博客

select distinct a.id, a.currentHandle, a.progressAndPlan, a.customerService, c.fullname as customerServiceName, d.f...

alter table table_name add column_name | nodify column_name | drop column column_name;add : 添加modify : 修改drop : 删除cascade constraints ： 约束

oracle那个系统表同时记录表名和表记录数的?select table_name , num_rows from user_tables;

Mysql数据库，Oracle数据库分别取得年，月，日。 年月，年月日。 Mysql语句：select substr(a.createtime, 1, 4) as statisticsName from defect1 a;select substr(a.createtime, 1, 7) as statisticsName from defect1 a;select su...

1.条件查询主任务数据异常:ORA-01861: 文字与格式字符串不匹配开始时间格式：to_date(t.beginDate,'yyyy-mm-dd')结束时间格式：to_date(t.endDate,'yyyy-mm-dd')if(beginDate != null && !"".equals(beginDate)) { if("1".equals(d...

if(Utility.isNotEmpty(taskVo.getSiteId()) && !"0".equals(taskVo.getSiteId())) { String si[] = taskVo.getSiteId().split("-"); build.append(" and st.siteId ='").append(si[0]).append("'"); ...

1.条件查询主任务数据异常:ORA-01861: 文字与格式字符串不匹配开始时间格式：to_date(t.beginDate,'yyyy-mm-dd')结束时间格式：to_date(t.endDate,'yyyy-mm-dd')if(beginDate != null && !"".equals(beginDate)) { if("1".equals(d...

select * from sitepro_attr where site_id ='CHN0224'and rownum

select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt from xj_inf x left join site1 s on x.siteName = s.site_id group by x.id ,x.siteName ,s.site_name , x.f...

创建时语句：CREATE SEQUENCE SEQ_SITEPRO_ATTR INCREMENT BY 1 START WITH 7922 NOCYCLE CACHE 10 ORDER;有触发器，后来需求原因，删掉触发器。修改触发器：CREATE OR REPLACE TRIGGER TRI_FOR_SITEPRO_ATTR BEFORE INSERT ON SITE...

1. 查询一张表里面索引 select * from user_indexes where table_name=upper('bills'); 2. 查询被索引字段 select * from user_ind_columns where index_name=('in_bills'); 3. 给某一字段创建索引 create index in_bills ...

这条语句总是报：ORA-00932: 数据类型不一致: 应为 -, 但却获得 BLOBselect * from ( select rownum as r, t.* from ( select a.id, a.dir, a.dirFlag, a.createTime, a.latelyTime, a.gcrms, a.title, a.siteName, a.status, b....

紧接第上篇文章。第一步：查看SQL语句。修改语句成：select a.id, b.name as statusName, a.currentHandle, a.progressAndPlan, a.customerService, ...

flashback table project_partys to timestamp to_timestamp('2014-07-24 17:00:00','yyyy-MM-dd hh24:mi:ss');