Saturday, 20 February 2016

PROCEDURE VS ANANYMOUS BLOCKS

PROCEDURE:
CREATE  OR  REPLACE  PROCEDURE P_EMP
 (A  IN       NUMBER,
  OUT   VARCHAR2,
  OUT    NUMBER,
  OUT    NUMBER)
IS
BEGIN
SELECT  ENAME,DEPTNO,SAL INTO B,C,D FROM  EMP  WHERE  EMPNO=A;
END;

ANANYMOUS BLOCK :
DECLARE 
A NUMBER;
B VARCHAR2(20);
C NUMBER;
D NUMBER;
BEGIN
SELECT  ENAME,DEPTNO,SAL INTO B,C,D FROM  EMP  WHERE  EMPNO=&A;
DBMS_OUTPUT.PUT_LINE( B);

DBMS_OUTPUT.PUT_LINE( C);
DBMS_OUTPUT.PUT_LINE( D);
END;
 




 

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.