获得前几行
select * from ( select rownum rnum, a.* from (your_query) a where rownum <= :M )where rnum >= :N;
将多列值转换为一行显示
Select Substr(Sys_Connect_By_Path(BRANCH_NO, ','), 2) From (Select Rownum Rid, Rownum + 1 Next_Rid, BRANCH_NO From branch_tab WHERE SENIOR = '11011') Where Rid = (Select Count(*) ...
EXECUTE IMMEDIATE 调用动态过程
v_str := 'begin '||trim(proc_name)||'(:1,:2); end;';EXECUTE IMMEDIATE v_str USING IN :NEW.bill_id,IN OUT v_out_message;
tree的tip:WHEN-TREE-NODE-SELECTED两次激活
WHEN-TREE-NODE-SELECTED在节点被选择和取消选择都会触发,如果只想触发一次可以使用下面的判断:IF :SYSTEM.TRIGGER_NODE_SELECTED = 'TRUE' THEN...
显示不符合KEY的记录
select * from mytable where rowid not in(select max(rowid) from mytable group by key)