Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 4036 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
What is a cognitive schema?
Why is oracle so popular?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
can u plz provide me oca sql dumps please i need them
How do I spool in oracle?
What is sharded cluster?
How to connect to oracle using service name instead of sid?
How to get a list of all user accounts in the database?
How to pass parameters to procedures?
How to use "if" statements on multiple conditions?
What is a tns service name?
Difference between oracle's plus (+) notation and ansi join notation?
Is a rollback possible to any savepoint?
What is a trigger and what are its types?
What is system global area (sga) in oracle?
