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.
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
What is sharded cluster?
How to export your own schema?
How to filter out duplications in the returning rows using oracle?
Where is the export dump file located?
What is the difference between sharding and replication?
How to assign query results to variables?
How to create an initialization parameter file?
Calculate difference between 2 date / times in oracle sql?
Is it possible to insert comments into sql statements return in the data model editor ?
How to define an anonymous block?
What is the difference between translate and replace?
How to use regular expression in pattern match conditions in oracle?
How would you change old and new values in an insert, delete and update triggers?
How to commit the current transaction in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?