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.

What is sqlerrm?

713

---

Why do we need a foreign key?

757

---

How exception is different from error?

762

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

702

---

How would you reference column values before and after you have inserted and deleted triggers?

818

---

---

Why is sql important?

761

---

What is sql mysql pl sql oracle?

784

---

How do I add a primary key to a table?

747

---

Explain the components of sql?

789

---

Why do we use procedures?

696

---

What has stored procedures in sql?

780

---

What is left join in sql?

751

---

What is the difference between the conventional and direct path loader? : aql loader

865

---

What are the different dml commands in sql?

762

---

What are the benefits of pl sql?

767

---