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 to enter numeric values as hex numbers? : Sql dba
How does join work in sql?
How do I count rows in sql query?
Mention what are different methods to trace the pl/sql code?
Why are indexes and views important to an organization?
What is use of term?
How to use boolean type in select statement?
how to escape special characters in sql statements? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
what happens if you no create privilege in a database? : Sql dba
Is sql pronounced sequel or sql?
What does stand for in sql?
Which one is better subquery or joins?
what are the properties and different types of sub-queries? : Sql dba
How many postgresql users are there, worldwide?