Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare
- --x varchar(20);
- x customers %rowtype;
- begin
- select * into x
- from customers
- where customer_id=200;
- if x.gender = 'F' then
- dbms_output.put_line('Ms. ' || x.cust_first_name);
- else
- dbms_output.put_line('Mr. ' || x.cust_first_name);
- end if;
- end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement