pl_sql_implicit_cursor_rowtype.sql

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;