hi this is really work create type addr as object ( add1 varchar2(15)

Hi,
I want table structure shown below. How can i create this ?
Num Name Address
Addr1 Addr2

I want Addr1 and Addr2 under Address column.
How can i achive this ? Is it possible ?

Question Posted / begum

2 Answers
5156 Views
IBM, I also Faced
E-Mail Answers

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

Is This Answer Correct ?

12 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to find out what oracle odbc drivers are installed?

1092

What is an oracle cursor variable?

1131

How do I escape a reserved word in oracle?

1254

Hi Can any one tell me what are the API's used in requisition import.

1971

What is the difference between translate and replace?

1116

How to bring a tablespace online?

1137

what are bitmap indexes? How does they work?

2302

How translate command is different from replace?

1140

How to store only time; not date and time?

1067

Explain an index?

1182

What is a parameter file in oracle?

1187

what is difference between sql plus and sql*plus? (not sql and sql plus).

3941

What is the difference between substr & instr functions?

1292

What is meant by an index?

1219

How to write a left outer join with the where clause in oracle?

1132