Hi,
I need help with an sql query that displays the last name of each student along with the first and last names of their advisors. I'm sure it can be done with and without calling the method. I would like help with both approaches if possible. I have 2 tables of student_type and faculty_type and Person_type is a super_type for both without a table.

create or replace type name_ty as object(
first varchar2(30),
last varchar2(30),
mi char(1),
member function get_fullname(
first IN varchar2,
last IN varchar2,
mi IN char
)return varchar2,
pragma restrict_references (get_fullname, RNDS, WNDS, RNPS,RNDS)
);
************************************************** *********
create type person_ty as object(
personName name_ty,
personAddress address_ty
) NOT FINAL;
************************************************** *******************

create type student_ty UNDER person_ty(
sid number(5),
phone varchar(10),
class char(2),
dob date,
fid number(5)
) NOT FINAL;
************************************************** ********************

create type faculty_ty UNDER person_ty(
fid number(5),
dept varchar2(4),
phone varchar2(10),
rank varchar2(8)
) NOT FINAL;