1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

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 are oracle functions?

551

What is procedure overloading in oracle?

544

What is oracle data type?

553

How do I limit the number of oracle database connections generated by weblogic server?

543

What is the string concatenation operator in oracle?

566




How to define and use table alias names in oracle?

505

Can you tell me how to add new column in existing views?how?How is possible?

928

How to define an anonymous procedure without variables?

545

Name the various constraints used in oracle?

562

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1470

What is set operator oracle?

524

How much memory your 10g xe server is using?

578

How to define a cusotmer as a supplier in ORACLE R12

1726

How to initialize variables with default values?

630

How to define an anonymous procedure with variables?

542