some people suggest to use this query : select * from employees where rownum <= 10 order by salary; but the problem with this will return a random set of ten rows ordered by salary which is not what I need.
Question
Oraask Latest Questions
Question
I have a PL/SQL procedure to update a number of rows in a table. is there is there any way to know the number of rows updated by update statement executed inside my procedure?
Question
I want to create a stored procedure with one parameter which will return multiple rows based on parameter value. how can i do this ?