Answer / 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.

Answer / chandu

create type addresstype as object
(hno varchar2(5),street varchar2(10),
city varchar2(10),pin varchar2(5));

Now we use this object in creating table like this.

create table employee(empno number(5),job varchar2(10),sal
number(5),empaddress addresstype);

insert into employee
values(101,'clerk',6000,addresstype('114a','gandhi','hyd',50001));

Answer / purushottam mishra

by using dynamic sql

How to rename a column in the output of sql query?

0 Answers  

---

What are tables in sql?

0 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

How do I find duplicates in a single column in sql?

0 Answers  

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

what are set operators in sql? : Sql dba

0 Answers  

---

What do you understand by pl/sql packages?

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

What are three advantages to using sql?

0 Answers  

---

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

What is partition in sql query?

0 Answers  

---