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.

how to enter numeric values as hex numbers? : Sql dba

1003

---

How does join work in sql?

956

---

How do I count rows in sql query?

937

---

Mention what are different methods to trace the pl/sql code?

1097

---

Why are indexes and views important to an organization?

897

---

What is use of term?

1006

---

How to use boolean type in select statement?

991

---

how to escape special characters in sql statements? : Sql dba

964

---

how can we know the count/number of elements of an array? : Sql dba

1003

---

what happens if you no create privilege in a database? : Sql dba

936

---

Is sql pronounced sequel or sql?

1212

---

What does stand for in sql?

915

---

Which one is better subquery or joins?

1007

---

what are the properties and different types of sub-queries? : Sql dba

966

---

How many postgresql users are there, worldwide?

989

---