SHARE
TWEET

Untitled

a guest Jun 16th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create or replace procedure new_emp_pro(cust_id in varchar2) as
  2.     v_ename varchar2(200):=null;
  3.     begin
  4.     select ename into v_ename from new_emp where empid=cust_id;
  5.     dbms_output.put_line('v_ename :'||v_ename);
  6.     end;
  7.     /
  8.  
  9.     PL/SQL procedure successfully completed.
  10.  
  11.     v_ename :
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top