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 |
definition of cluster and non-clustered index?
What is the maximum limit on the number of columns in a table?
What is a deadlock in SQL? How can you prevent it?
What is Undo Management Advisor in Oracle?
How to create additional tablespaces for an new database?
How to add another datafile to a tablespace?
What to do if the startbd.bat failed to start the xe instance?
Can we insert data in view oracle?
How to specify default values in insert statement using oracle?
What are cursor?where are they used?
What are the types of Database Links ?
What is null value in oracle?