DECLARE -- Declaration section
v_ename emp.ename%type ;
BEGIN -- Execution section
Select ename into v_ename
from emp
where empno = '7219';
DBMS_OUTPUT.PUT_LINE(v_ename);
END;
INPUT : NA
OUTPUT : John (the corresponding ename for empno given will be displayed)
v_ename emp.ename%type ;
BEGIN -- Execution section
Select ename into v_ename
from emp
where empno = '7219';
DBMS_OUTPUT.PUT_LINE(v_ename);
END;
INPUT : NA
OUTPUT : John (the corresponding ename for empno given will be displayed)
No comments:
Post a Comment
Please Give Your Comments!!
Note: Only a member of this blog may post a comment.