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 do I turn a list into a table?

960

---

How do I filter in sql profiler?

994

---

how to include comments in sql statements? : Sql dba

955

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

---

What is the usage of the distinct keyword?

1220

---

What are sql commands?

1010

---

How do you break a loop in pl sql?

1049

---

What is the location of pre_defined_functions.

1166

---

what is innodb? : Sql dba

1105

---

Is there any restriction on the use of union in embedded sql?

1157

---

What is sap sql?

982

---

What is clause?

1151

---

What is indexes?

1058

---

what is meant by urlencode and urldocode? : Sql dba

1176

---

What is sql*loader and what is it used for?

1153

---