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 toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

---

What is bind variable in pl sql?

0 Answers  

---

what are the authentication modes in sql server? : Sql dba

0 Answers  

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

How many aggregate functions are available there in sql?

0 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

diff b/w function and procedure?

9 Answers   iFlex,

---

What are the triggers associated with image items?

0 Answers  

---

What is lookup table in sql?

0 Answers  

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---