Accessing Object Attributes
DECLARE
emp EMPLOYEE_TYP;
BEGIN
emp := Employee_typ(315,'Francis','Logan','FLOGAN','555.777.2222',
'01-MAY-04','SA_MAN',11000,.15,101,110,Address_typ('376 Mission','San Francisco','CA','94222'));
dbms_output.Put_line(emp.first_name
||' '
||emp.last_name);
dbms_output.Put_line(emp.address.street);
dbms_output.Put_line(emp.address.city
||', '
||emp.address.state
||' '
||emp.address.postal_code);
END;
/
OUTPUT:-
Francis Logan
376 Mission
San Francisco, CA 94222
PL/SQL procedure successfully completed.
0 comments:
Post a Comment