http://zhidao.baidu.com/link?url=APKpO_ktmLa4QE0ZYlOqKyNdLul4rkDbV-LXBeDv40sHe0yDXS-LGc4A3ArNL2Ro-TTSb0SbSOM8Co1xhBf5PR9iX5eU6yV-fznLs_0OJhyalter system flush shared_pool ; alter system flush BUFFER_CACHE ; ...【阅读全文】
输入的数决定显示人数。EX:输入2,就显示最高的2人名字。1.create procedureCREATE OR REPLACE PROCEDURE pro_emp (nu IN NUMBER) ISCURSOR cur_emp IS SELECT ename FROM (SELECT ename,row_number()over(ORDER BY sal DESC) rn FROM emp) t WHERE t.rn<=nu;BEGIN  ...【阅读全文】