笨笨个人笔记

首先，找到数据删除前的一个时间点。select timestamp_to_scn(to_timestamp('2013-10-12 8:30:00', 'YYYY-MM-DD HH24:MI:SS')) from dual;如，我这里得到的点为36551273744。然后根据这个点找到你所删除文件的表的数据。使用一个临时表把这些数据存放起来。create t

select * from product_info t where t.contract_detailid is not nulland length(translate(t.contract_detailid,'-.0123456789'||t.contract_detailid,'-.0123456789'))

select a.id,a.oacode,a.custid,a.custname,a.xsz,a.salename,a.communicationtheme,a.communicationproperty,a.communicationtime,a.productmanager,'' creator,a.creator oaCreator,a.createdate,case when a.oast

select * from (select a.id,a.oacode,a.custid,a.custname,a.xsz,a.salename,a.communicationtheme,a.communicationproperty,a.communicationtime,a.productmanager,a.creator,a.createdate from technology_flow

select p.id comperitorId,p.compcorp competitorName,sum(case when c.kindname = 'ATM' then c.num else 0 end) atm,sum(case when c.kindname = 'CRS' then c.num else 0 end) crs,sum(case when c.kindname

-- Create tablecreate table TECHNOLOGYCOMPANY( ID VARCHAR2(32) default SYS_GUID() not null, FLOWID VARCHAR2(50), CONPANYID NUMBER, ISCOMMUNICATION VARCHAR2(10))

update product_info t set (t.salename,t.xsqy)=(select c.salename,c.xsqy from contract_erp c where c.contractcode=t.contractid)where t.contractid in(select c.contractcode from contract_erp c) and t.co

select rownum||'' as id,t.materialname as prodCode,t.ename as prodName,t.materialtype||'_'||t.groupcode as kindName,t.unit as unit,'' as spec,'' as price,t.materialcode as remark from material_mast

今儿在自己电脑上搭建开发环境，在给数据库导入表结构以及数据时报1659错误，错误内容如下：IMP-00017: 由于 ORACLE 错误 1659, 以下语句失败:        "CREATE TABLE "T_DATA_KKCL"…………IMP-00003: 遇到 ORACLE 错误 1659ORA-01659: 无法分配超出 6 的 MINEXTENTS (在表空

1、设置计划explain plan for select * from ( select * from dun_search_view where 1=1 and (( salename='陈永智' and xsqy='广州办事处') or (','||fzuserid||',' like '%,6839951,%')) ) where rownum <= 30;2