Guest User

Untitled

a guest
Jun 25th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. DECLARE
  2.  
  3. c_id number:=1; //initialize id to 1 as we want ot find customer with id:=1
  4. c_name varchar(20);
  5.  
  6. BEGIN
  7.  
  8. SELECT id,name INTO c_id,c_name //create table customer(id,name) hence understand
  9. from customer //customer table created already
  10. where
  11. id=c_id;
  12.  
  13. dbms_output.put_line('id'||c_id);
  14. dbms_output.put_line('name'||c_name);
  15.  
  16.  
  17.  
  18. END;
Add Comment
Please, Sign In to add comment