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 sql clause?

1002

---

What is the location of pre_defined_functions.

1121

---

Define implicit and explicit cursors.

1087

---

How can we find duplicate records in a table?

902

---

What is trigger point?

956

---

What is difference between sql and mysql?

1070

---

List out the acid properties and explain?

914

---

What are the uses of merge?

1123

---

Which one is better subquery or joins?

1014

---

what are the differences between binary and varbinary? : Sql dba

988

---

What are the datatypes available in pl/sql ?

1052

---

What is Difference Between Unique and Primary Key Constraints?

1065

---

what is table? : Sql dba

1000

---

Can we write ddl statements in functions?

1058

---

Can we use ddl statements in stored procedure?

1103

---