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
- 3063 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
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain view?
Differentiate between function and procedure in oracle.
Why do you create or replace procedures rather that drop and recreate.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Explain an index segment?
What is an oracle transaction?
What is meant by an index?
Explain the use of online redo log files in oracle.
Is there a function to split a string in plsql?
What is a data dictionary and how can it be created?
State some uses of redo log files?
What privilege is needed for a user to create tables in oracle?
