Answer Posted / begum

hi this is really work

create type addr as object (
add1 varchar2(15),
add2 varchar2(15));
/
create table nest1 (
id number(2),
name varchar2(10),
address addr);

insert into nest1 values(10,'uma',addr('10th
main','bangalore'));
/
insert into nest1 values(20,'sami',addr('77g
colony','chennai'));

SQL> select * from nest1;

ID NAME
---------- ----------
ADDRESS(ADD1, ADD2)
--------------------------------------------
10 uma
ADDR('10th main', 'bangalore')

20 sami
ADDR('77g colony', 'chennai')

What are the uses of synonyms?

1083

---

What happens if the update subquery returns multiple rows?

1042

---

How to define an anonymous block?

1072

---

What are the differences between date and timestamp in oracle?

973

---

How to insert multiple rows with one insert statement in oracle?

1020

---

What are the tools for Oracle ?

1007

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4479

---

What is Library Cache in Oracle?

1075

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1936

---

Explain what are the characteristics of data files?

1030

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1696

---

How to drop an index in oracle?

1019

---

How to execute a stored program unit?

1004

---

How to define a variable of a specific record type?

1017

---

How to create a new table in oracle?

1065

---