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
4143 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

Can we use bind variables in oracle stored procedure?

983

How to assign values to variables?

1163

What is the difference between $oracle_base and $oracle_home?

1136

What is recycle bin in Oracle?

1192

What is transaction control statement and how many types of transaction control statement in Oracle?

1230

Explain oracle’s system global area (sga).

1185

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1093

What is ceil and floor in oracle?

1118

What is analyze command used for?

1122

query optmization techniques and quwry analyser+projects+ppts

2464

How to get last row id?

1049

How to use subqueries with the exists operator in oracle?

1066

What are the uses of a database trigger?

1035

Can a formula column referred to columns in higher group ?

2550

State and explain about oracle instance?

1049