You question is having two different levels. First how write simple stored procedure and next how get result set back for report
In oracle you need to write stored procedure on notepad and execute it at PL/Sql prompt. I have given here an example executed this SQL prompt.
Create or replace...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.