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.
- 1 Answers
- 2887 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer / reddy
create type obj1 as object(addr1 varchar2(30),addr2 varchar2(30)); create type bbb as table of obj1; create tableemployee(no number(9),name varchar2(19), address bbb);
| Is This Answer Correct ? | 1 Yes | 0 No |
Can a Tablespace hold objects from different Schemes ?
what are corelated subqueries
How many types of segments in Oracle?
Can group functions be used in the order by clause in oracle?
How will you differentiate between varchar & varchar2?
What is Private Database Link ?
What is catalog in Oracle?
What is merge in oracle?
What is background process in Oracle?
How to view all columns in an existing table?
What is an Oracle index?
How to use in conditions in oracle?
Oracle General 
