create type obj1 as object(addr1 varchar2(30),addr2 varchar2(30)); crea

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 / reddy

1 Answers
2977 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

Please Help Members By Posting Answers For Below Questions

How do I reset a sequence in oracle?

1103

Will you be able to store pictures in the database?explain.

995

What is sequence?

1087

What happens to the indexes if a table is recovered?

993

How to commit the current transaction in oracle?

1124

What privilege is needed for a user to create tables in oracle?

953

Oracle

2380

Which is better Oracle or MS SQL? Why?

6391

6. Display the client name and order date for all orders using the traditional method.

2309

When do we use group by clause in a sql query?

1039

What do you mean by merge in oracle and how can we merge two tables?

1051

What do you mean by group by clause?

1047

How to convert characters to dates in oracle?

1103

How to use windows user to connect to the server?

990

What is the max number of columns in an oracle table?

1001