摘要:
delete from vitae where rowid in (select min(rowid) from vitae group by peopleId,seq having count(*)>1) 阅读全文
摘要:
select * from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1) 阅读全文
摘要:
delete from people where rowid in (select min(rowid) from people group by peopleId having count(peopleId )>1) 阅读全文
摘要:
select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) 阅读全文
摘要:
insert into 表名 select * from 表名 as of timestamp to_Date('2017-07-20 10:00:00', 'yyyy-mm-dd hh24:mi:ss'); COMMIT; 阅读全文
摘要:
alter index 索引名 rebuild 阅读全文
摘要:
SELECT * FROM 表名 t WHERE(to_char(t.日期字段,'yyyy-MM-dd hh24:mi:ss')like '%2011%') 阅读全文
摘要:
alter table 表名 move tablespace 新的表空间名 阅读全文
摘要:
ID字段必须是唯一的,然后根据NAME字段的值去重,获得的结果 阅读全文
摘要:
我们对MVC 并不陌生, 在创建MVC项目时,总会发现,在工程目录 中有两个 web.config 文件,一个是在工程的根目录下,一是在 views 下,两个web.config 中的内容也不尽相同,那么为什么会有两个 web.config 文件,这就是这篇随笔将要说明的。 根目录下的web.con 阅读全文