Answer Posted / madhavi
SQL> set serverout on
SQL>
SQL> create or replace
2 type new_person as object (
3 last_name varchar2(100),
4 phone varchar2(100),
5 member function get_last_name return varchar2,
6 member function get_phone_number return varchar2 )
7 not final
8 /
Type created.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How do I turn a list into a table?
How do I filter in sql profiler?
how to include comments in sql statements? : Sql dba
how to dump a table to a file with 'mysqldump'? : Sql dba
What is the usage of the distinct keyword?
What are sql commands?
How do you break a loop in pl sql?
What is the location of pre_defined_functions.
what is innodb? : Sql dba
Is there any restriction on the use of union in embedded sql?
What is sap sql?
What is clause?
What is indexes?
what is meant by urlencode and urldocode? : Sql dba
What is sql*loader and what is it used for?