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 use "in" parameter properly?

1073

---

In which language oracle has been developed?

1076

---

What is oracle database client?

1034

---

What happens to the current transaction if the session is killed?

990

---

How to divide query output into groups in oracle?

992

---

how to join query for one source type is oracle another source type is sql server ?

2428

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

---

What is a package ? What are the advantages of package ?

1093

---

What is transport network substrate (tns) in oracle?

1047

---

How would you change old and new values in an insert, delete and update triggers?

1022

---

How to connect to the server with user account: sys?

1024

---

How to convert numbers to characters in oracle?

1030

---

What do you mean by group by clause?

1047

---

What is bulk load in oracle?

1070

---

What is a data dictionary and how can it be created?

1152

---