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
- 2270 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
Point out the difference between user tables and data dictionary?
How many types of cluster table in Oracle?
What are the uses of Database Trigger ?
How to view all columns in an existing table?
How do we get field details of a table?
what is the difference between restoring and recovering?
Explain a segment?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to divide query output into groups in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Explain the importance of .pll extension in oracle?
How to use regular expression in pattern match conditions in oracle?
What is the difference between pre-select and pre-query?
