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.

Why stored procedure is faster than query?

1067

---

What is a clob in sql?

1026

---

Explain normalization and what are the advantages of it?

954

---

What are the advantages of pl sql over sql?

1028

---

What is index example?

1013

---

what is an index? : Sql dba

1003

---

Which nosql database is best?

986

---

Write a query to display the current date in sql?

1031

---

what are the join types in tsql? : Transact sql

1068

---

What is sql procedures and functions?

1012

---

what are rollup and cube in t-sql? : Transact sql

1104

---

How to avoid duplicate records in a query?

1012

---

How does rowid help in running a query faster?

1420

---

What is t sql in sql server?

1079

---

Which command is used to call a stored procedure?

1006

---