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
- 2415 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 |
what is kernel?
What is Read-Only Transaction ?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
what is the dual table in oracle?
What is bulk copy or bcp in oracle?
Explain the use of rows option in exp command.
What is an oracle user account?
What a SELECT FOR UPDATE cursor represent.?
Explain implicit cursor.
Differnce between view and index
What do you mean by merge in oracle?
What are the different type of Segments ?
Oracle General 
