I am experienced in MS SQL Server, but new to Oracle.
I need to create a simple stored procedure that executes a SQL statement which returns rows from a table.
create or replace procedure P_DBMTEST
(EmployeeNumber) AS ;
SELECT * FROM Employee
WHERE Employee.EmployeeNumber = Input parameter for the employee number.
Then I need to run the procedure in a SQL statement.
Reference to an exammple would help.