Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. declare
  2. --x varchar(20);
  3. x customers %rowtype;
  4. begin
  5. select * into x
  6. from customers
  7. where customer_id=200;
  8. if x.gender = 'F' then
  9. dbms_output.put_line('Ms. ' || x.cust_first_name);
  10. else
  11. dbms_output.put_line('Mr. ' || x.cust_first_name);
  12. end if;
  13. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement