Posted by: eserhan on: February 19, 2009
Partition is made over dept_no and ordered by salary for both rank and dense_rank. They both make the same job except the numeric ranking. The same number is assigned for records with the same order value in both of them. At dense_rank, the numeric assignment is made sequentially for next row. But in rank, it is not [...]
Posted by: eserhan on: February 19, 2009
this is a small hint to get a guick EXPLAIN PLAN when your ambulance button is not working at TOAD and you have limited time EXPLAIN PLAN FOR SELECT * from something; set pagesize 25 set linesize 121 SELECT * FROM TABLE(dbms_xplan.display); just run this as script..
