Advertisement
Guest User

Untitled

a guest
Jun 15th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. create or replace
  2. TYPE student_object AS OBJECT
  3. (IDSTUDENT number,
  4. STUDENT_FIRSTNAME varchar2(30),
  5. STUDENT_LASTNAME varchar2(30),
  6. USERNAME varchar2(30),
  7. PASSWORD varchar2(30),
  8. STUDENT_CMND varchar2(30),
  9. GENDER number,
  10. BIRTHDAY date,
  11.  
  12. member function enlarge return student_object,
  13. NOT FINAL member procedure display) NOT FINAL;
  14. //
  15. create or replace
  16. TYPE BODY student_object AS
  17. MEMBER FUNCTION enlarge return student_object IS
  18. BEGIN
  19. return student_object(self.IDSTUDENT, self.STUDENT_FIRSTNAME,self.STUDENT_LASTNAME,self.USERNAME, self.PASSWORD,self.STUDENT_CMND,self.GENDER, self.BIRTHDAY);
  20. END enlarge;
  21. MEMBER PROCEDURE display IS
  22. BEGIN
  23. dbms_output.put_line('ID: '|| IDSTUDENT);
  24. dbms_output.put_line('STUDENT_FIRSTNAME : '|| STUDENT_FIRSTNAME);
  25. dbms_output.put_line('STUDENT_LASTNAME : '|| STUDENT_LASTNAME);
  26. dbms_output.put_line('USERNAME : '|| USERNAME);
  27. dbms_output.put_line('PASSWORD: '|| PASSWORD);
  28. dbms_output.put_line('STUDENT_CMND: '|| STUDENT_CMND);
  29. dbms_output.put_line('GENDER : '|| GENDER);
  30. dbms_output.put_line('BIRTHDAY : '|| BIRTHDAY);
  31. END display;
  32. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement