oracle sql 小记。

--select * from tab1 where acldate > to_date('2013-02-05','yyyy-mm-dd') and object_id='{04564890-64C7-4703-AC23-B324CDE01B69}'

--select * from tab2 where object_id ='{04564890-64C7-4703-AC23-B324CDE01B69}'


去重复
--select distinct owner,object_id,objecttype from downloadaccess 
--select count(1) from downloadaccess


--select * from downloadaccessdistinct

/**
insert into downloadaccessdistinct(owner,objecttype,objectstore,object_id)
select a.owner,a.objecttype,a.objectstore,a.object_id from (select distinct owner,objecttype,objectstore,object_id from downloadaccess) a
*/
create table downloadaccessDistinctTemp as (select distinct * from downloadaccess)


创建零时表
--create table downloadaccessDistinctTemp as (select distinct * from dmsos.downloadaccess)

--select * from dmsos.downloadaccess

--select count(*) from downloadaccessDistinctTemp

/**
insert into dmsos.downloadaccessdistinct(owner,objecttype,objectstore,object_id)
select a.owner,a.objecttype,a.objectstore,a.object_id from downloadaccessDistinctTemp a
**/
插入数据
--insert into dmsos.downloadaccess (select * from downloadaccessdistinctTemp)

--delete from dmsos.downloadaccess

删除数据
--truncate table dmsos.downloadaccess --drop storage nowait
oracle提醒nowait时 需要注销操作session

--select count(*) from dmsos.downloadaccess
--select session_id from v$locked_object

--select sid,serial#,username,osuser from v$session where sid = 18

--alter system kill session '18,48111'