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.
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 an Index ?
How to rename a column in an existing table?
Can we create more than one index on particular column?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to delete a column in an existing table?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Difference between inner join vs where ?
Which is better Oracle or MS SQL? Why?
What is a View ?
What is a database schema in oracle?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
When do you get a .pll extension in oracle?