maypol的专栏

sqlif not exists (select * from uuv_user where userid=UR1100017647) insert into uuv_user (userid, username,displayname,telephone) values(UR1100017647, suxf,苏肖飞,)oracle insert

SQL> select member from v$logfile;MEMBER--------------------------------------------------------------------------------/home/ora10g/oradata/orcl/redo03.log/home/ora10g/oradata/orcl/redo02.log

*1.FLASHBACK QUERY*/ --闪回到15分钟前 select * from orders as of timestamp (systimestamp - interval '15' minute) where ...... 这里可以使用DAY、SECOND、MONTH替换minute，例如： SELECT * FROM orders AS OF TIMESTA

创建用户导入数据create user dldb identified by dldb default tablespace DLDATAgrant connect,resource,create view to dldb;revoke unlimited tablespace from dldbalter user dldb quota unlimited on DLDATA

修改链接数show parameter processesalter system set processes=2000 scope=spfile;查看连接个数select count(*) from v$session where status='ACTIVE';Too many open files in systemecho "9234560">/proc

创建用户导入数据create user dldb identified by dldb default tablespace DLDATAgrant connect,resource,create view to dldb;revoke unlimited tablespace from dldbalter user dldb quota unlimited on DLDATA

#!/usr/bin/kshecho "start delete link"querysessionnum=`sqlplus / as sysdba Select count(*) from v\\$session where status='INACTIVE'; Select sid,SERIAL# from v\\$session where status='INACTIVE'

1.查看数据库表的使用空间select tablespace_name,sum(bytes)/1024/1024 from dba_data_files  group by tablespace_name;2.查看数据库剩余表空间SELECT tablespace_n

语句先判断要删除表的对象是否存在，如果存在则插入一条新数据，如果不存在则先创建一个删除表，再插入相应数据表对象：TableName 删除表对象：TableName_deled主键ID：pCol 其它列名：Fields             if (!TableName.Contains("_deled"))            {               

(一)1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断select * from peoplewhere peopleId in (select  peopleId  from  people  group  by  peopleId  having  count(peopleId) > 1)2、删除表中多余的重复记录，重复记录是根据单个字段（p

select nvl2(replace(translate(69584.00.00,.0123456789,000000000000),0,),否,是) IsNumber from dual;select id,nvl2(replace(translate(id,.0123456789,000000000000),0,),否,是) I

1.绝对值 S:select abs(-1) valueO:select abs(-1) value from dual2.取整(大) S:select ceiling(-1.001) value O:select ceil(-1.001) value from dual3.取整（小） S:select floor(-1.001) value O:selec

       select * from (  select cw2.NO WHOLENO,sp1.ARGUMENTNAME TYPENAME,sp2.ARGUMENTNAME BRANDNAME,sp3.ARGUMENTNAME STYLENAME,sp4.ARGUMENTNAME DEPART,so.OPERATORNAME USERNAME   from COM_WHOLE_IN

Oracle Connect By用法 oracle中的select语句可以用START WITH...CONNECT BY PRIOR子句实现递归查询，connect by 是结构化查询中用到的，其基本语法是：select ... from where start with connect by ;：过滤条件，用于对返回的所有记录进行过滤。：查询结果

select RECORD_ID.NEXTVAL as id from dual

查数据库中表的任n行的记录:select * from ( select rownum x ,tab.* from tab) where x in (2,3); 查询出数据库中表大于1000的记录: select * from ( select rownum x ,tab.* from tab) where x>1000如何插入'字>select '''' from dual;