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 does the t-sql command ident_incr does? : Transact sql

601

---

Enlist the data types that can be used in pl/sql?

574

---

how many groups of data types? : Sql dba

569

---

What do you understand by pl/sql packages?

570

---

What are types of exception?

538

---

---

Is sqlexception checked or unchecked?

536

---

How do you update f as m and m as f from the below table testtable?

1079

---

What are data types in pl sql?

564

---

What is pragma in sql?

622

---

How do I save the results of sql query in a file?

535

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

556

---

What is graph sql?

526

---

When is the explicit cursor used ?

588

---

How to run sql statements through the web interface?

514

---

What is the difference between left join and right join?

502

---