发布时间：2014-02-26 17:04:03

1.CREATE OR REPLACE PACKAGE ROME AS AS TYPE RefCursor IS REF CURSOR; Function GetCompany(key IN char) return RefCursor; END; / CREATE OR REPLACE PACKAGE BODY ROME IS IS Function GetCompany(key IN cha.........【阅读全文】

发布时间：2013-11-20 17:14:29

select dbms_random.value from dual;select dbms_random.value(1,100) from dual;SELECT dbms_random.random FROM DUAL;select dbms_random.normal from dual;select dbms_random.string('u',26) from dual;--upper caseselect dbms_random.string('l',26) .........【阅读全文】

发布时间：2013-10-11 17:25:48

http://www.itpub.net/thread-1336505-1-1.html 之dingjun123回覆--按salary排序，计算当前行到下面两行的salary累加值，红色部分为例，可以看到2340等于3个salary的值，物理行范围，一眼看就看出来了SQL> select id,last_name,salary,dept_id,  2  sum(salary) over(order by.........【阅读全文】