sort curser-values in pl/sql

[mokesql]

hi!

i want to sort my curser values by the alphabet, so as example: my curser contains three columns, one of them is the name and i want to insert all the rows into a table but i want them sorted alphabetic. how can i do it? please helt, thnx

kemo

 

[rcurva]

Your cursor will be something like this.

cursor samp_curr is
SELECT name, emp_no, salary
FROM emp
ORDER BY name;