DECLARE
V_EMP EMP%ROWTYPE;
BEGIN
SELECT * INTO V_EMP FROM EMP WHERE EMPNO=&EMPNO;
DBMS_OUTPUT.PUT_LINE(V_EMP.ENAME||' '||V_EMP.SAL||' '||V_EMP.DEPTNO);
END;
V_EMP EMP%ROWTYPE;
BEGIN
SELECT * INTO V_EMP FROM EMP WHERE EMPNO=&EMPNO;
DBMS_OUTPUT.PUT_LINE(V_EMP.ENAME||' '||V_EMP.SAL||' '||V_EMP.DEPTNO);
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.