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
- 4023 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 are the data types in oracle?
How to drop an index?
What is BBED in Oracle?
How do I manually create a database in oracle?
What are a collation and state the different types of collation sensitivity?
What is a nvl function?
What is Reduced List of Values?
How to select all columns of all rows from a table in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Please explain oracle left join with an example?
How to loop through a cursor variable?
What is oracle sid?
What is user managed backup in Oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to insert a new row into a table in oracle?
