Easy selection inside Oracle stored procedure

Question

How to create a stored procedure using simple selection (SELECT * FROM TABLE) using Oracle? Also, any helpful stored procedure guides would help a lot.

Thank.

Answer 1

It depends on what you are trying to return from the stored procedure (resultet vs scalar value) and which version of Oracle you are using (newer versions make this easier).

This question is probably a trick. Get the result set from the oracle stored procedure .

Answer 2

create or replace procedure spr_select_Emp(eno in number, employee out emp%RowType)
As

Begin
   Select empno,ename,mgrno,hiredate,sal,comm,deptno into employee from emp
   where empno=eno
End;

Answer 3

Oracle :

() ( )

   ;

more details here: http://www.dba-oracle.com/t_create_or_replace_procedure.htm