PROCEDURE:
CREATE OR REPLACE PROCEDURE P_EMP
(A IN NUMBER,
B OUT VARCHAR2,
C OUT NUMBER,
D 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;
CREATE OR REPLACE PROCEDURE P_EMP
(A IN NUMBER,
B OUT VARCHAR2,
C OUT NUMBER,
D 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.