Donny's Blog

SELECT except_timeFROM (SELECT MIN(except_time) as except_time, normal_order_no FROM KL_PRODPLAN_OPERATION_ORDER WHERE normal_order_no IN ('HL11070009','HL11080004') AND except_time...

原文引自 http://www.cnblogs.com/linc09/archive/2011/04/27/2031223.htmlOracle中的rownum的是在取数据的时候产生的序号，所以想对指定排序的数据去指定的rowmun行数据就必须注意了。SQL> select rownum ,id,name from student order by name; RO...

select * from user_tab_columns where column_name like upper('%handler%')

SET serveroutput ON size 1000000; DECLARE seq_id VARCHAR2(36); begin select ECC_FND.ECC_FND_ACL_INFO_S.NEXTVAL into seq_id from dual; dbms_output.put_line(seq_id); --your sql, 这里可以用上 seq_id ...

先贴上查询语句WITH resultTable AS ( SELECT b.STAND_CFG_PRI_ID, b.PRODFAM_ID, b.PRODFAM_CODE, b.PRODUCT_LINE_ID, b.PRICE_LOOUP_TYPE, b.PRI...

在Oracle中查看所有的表及其索引和约束（转）  2012-09-10 23:40:08|  分类： 表空间，视图，索|字号 订阅  from：http://space.itpub.net/?uid-27129443-action-viewspace-itemid-742916在Oracle中查看所有的表:select * from tab/dba_t...