Yes you can. Just use the nested table concept . Then u can make another t

I want a table like,
no name address
addr1 addr2

So i want columns like addr1,addr2 under address column.
Can one please answer me.
Advance Thanks.

Question Posted / sudipta santra

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

Answer Posted / sudipta santra

Yes you can. Just use the nested table concept . Then u can
make another table under the column Address. For a
particular row one address value can also hold the multiple
value for addr1 and addr2.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is execute immediate in oracle?

948

What is the oracle implicit cursor?

994

What is an oracle data file?

1035

Explain joins in oracle?

976

How to write a query with a right outer join in oracle?

1108

How can you merge two tables in oracle?

935

Does oracle charge for java?

1005

Calculate difference between 2 date / times in oracle sql?

985

How to create a new tablespace in oracle?

932

What is a sub query? Describe its types?

962

How to define a specific record type?

1034

How to use "out" parameter properly?

1020

What is varray?

1030

Explain the use of Merge statement in oracle 11g

974

How to write a query with a left outer join in oracle?

998