Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace
- TYPE student_object AS OBJECT
- (IDSTUDENT number,
- STUDENT_FIRSTNAME varchar2(30),
- STUDENT_LASTNAME varchar2(30),
- USERNAME varchar2(30),
- PASSWORD varchar2(30),
- STUDENT_CMND varchar2(30),
- GENDER number,
- BIRTHDAY date,
- member function enlarge return student_object,
- NOT FINAL member procedure display) NOT FINAL;
- //
- create or replace
- TYPE BODY student_object AS
- MEMBER FUNCTION enlarge return student_object IS
- BEGIN
- return student_object(self.IDSTUDENT, self.STUDENT_FIRSTNAME,self.STUDENT_LASTNAME,self.USERNAME, self.PASSWORD,self.STUDENT_CMND,self.GENDER, self.BIRTHDAY);
- END enlarge;
- MEMBER PROCEDURE display IS
- BEGIN
- dbms_output.put_line('ID: '|| IDSTUDENT);
- dbms_output.put_line('STUDENT_FIRSTNAME : '|| STUDENT_FIRSTNAME);
- dbms_output.put_line('STUDENT_LASTNAME : '|| STUDENT_LASTNAME);
- dbms_output.put_line('USERNAME : '|| USERNAME);
- dbms_output.put_line('PASSWORD: '|| PASSWORD);
- dbms_output.put_line('STUDENT_CMND: '|| STUDENT_CMND);
- dbms_output.put_line('GENDER : '|| GENDER);
- dbms_output.put_line('BIRTHDAY : '|| BIRTHDAY);
- END display;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement