Hi All, I am a new oracle user and i needed some help please.
I have a table called staff with info such as name, grade etc.
I want to create a stored procedure so grade was a parameter and it will bring back staff at that grade.
For example the simple SQL would be select firstname, lastname FROM staff where grade = 1
How would i go about creating a stored procedure so i could use grade as a parameter.
Would it be something like this:
Create or replace procedure grade.proc
(grade AS number)
IS
Begin
?
Thank you for your help, i am sorry for this is very basic.