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')

How to load data from external tables to regular tables?

1011

---

What is the sql query to concatenate column values from multiple rows in oracle?

1013

---

Why does for update in oracle 8 cause an ora-01002 error?

952

---

Respected sir, Please send me technical questions related to oracle apps..

1777

---

How data locks are respected in oracle?

1025

---

What is a nvl function? How can it be used?

972

---

How to export your own schema?

984

---

How to see the table columns used in an index?

979

---

What do you understand by a database object? Can you list a few of them?

987

---

Explain oracle’s system global area (sga).

1097

---

query optmization techniques and quwry analyser+projects+ppts

2383

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

935

---

Difference between cartesian join and cross join?

983

---

How to define an oracle cursor variable?

988

---

How to import one table back from a dump file?

988

---