I want a table like, no name address addr1 addr2 So i want colum

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.

Question Posted / manojkumar

1 Answers
3033 Views
IBM, Wipro, I also Faced
E-Mail Answers

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 ..

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

Post New Answer

More Oracle General Interview Questions

What is an Index ?

2 Answers

How to rename a column in an existing table?

0 Answers

Can we create more than one index on particular column?

1 Answers

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.

6 Answers

How to delete a column in an existing table?

0 Answers

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers Wipro,

Difference between inner join vs where ?

0 Answers

Which is better Oracle or MS SQL? Why?

2 Answers Bally Technologies,

What is a View ?

3 Answers

What is a database schema in oracle?

0 Answers

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.

2 Answers Wipro,

When do you get a .pll extension in oracle?

0 Answers

For more Oracle General Interview Questions Click Here