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
- 4042 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 concurrency in oracle?
How to start instance with a minimal initialization parameter file?
What is a view and how is it different from a table?
What is the data pump export utility?
Explain the types of exception?
How a tablespace is related to data files?
How to create a temporary table in oracle?
What is hot backup and logical backup?
How to write date and time interval literals in oracle?
What is a dead lock in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
How will you differentiate between varchar & varchar2?
What are the ansi data types supported in oracle?
What is java oracle used for?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
