YanQiuXiang

declare i int:=1; begin while i        dbms_output.put_line(i);i:=i+1; end loop;  end;

SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY x ORDER BY y DESC) rn, test1.* FROM test1) WHERE rn = 1 ;

获取一段时间内所有的小时SELECT to_date('2013-07-01 12', 'yyyy-mm-dd hh24') + (ROWNUM - 1) / 24 sdate FROM dualCONNECT BY ROWNUM (to_date('2013-07-02 22', 'yyyy-mm-dd hh24') - to_date('2013-07-01 12', 'yyyy-

BEGINfor i in 1..10000 loop insert into BN_USER(USER_ID,USER_PHONE,USER_SEX,REGISTER_TIME,WECHAT) values(BN_USER_REQUENCE.NEXTVAL,i,0,sysdate,'oHOlkwWViA6GuFRkcd0tPFTxmPM4'||i);end loop;end;

比如半段字段col中是否好友字符"a"instr(col,'a')>0表示包含 =0表示不包含

selectcase when exists(select1 fromt_test c wherec.name= 'zhangsan'    andc.age = 23 ) then1 else0 endfromdual;

1、查询锁表SELECT /*+ rule */ lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name, o.owner,o.object_name,o.object_type,s.sid,s.serial#FROM v$locked_object l,dba_objects o,v$session s WHERE l

select f1,f2,f3 into v1,v2,v3 from tab1

oracle树查询的最重要的就是select…start with…connect by…prior语法了。依托于该语法，我们可以将一个表形结构的数据以树的顺序列出来。在下面列述了oracle中树型查询的常用查询方式以及经常使用的与树查询相关的oracle特性函数等，在这里只涉及到一张表中的树查询方式而不涉及多表中的关联等。1、准备测试表和测试数据--菜单目录结构表create ta

CREATE OR REPLACE PROCEDURE MEMBERINFO_PROCEDURE ( markerId in number, memberId in number, consume_type in int, scoreInfo in number, remarkInfo in varchar2, session_id in numbe

String str = req.getParameter("data");JSONObject jo = JSONObject.fromObject(str);Connection connection = DataProxool.getOneConnection();// 获取一个连接池PreparedStatement cmd = null;try {connecti