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
2968 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 you find current date and time in oracle?

1044

What is format trigger?

2063

Difference between inner join vs where ?

1032

How to create a new tablespace in oracle?

979

Explain the use of indexes option in exp command.

1139

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1105

Explain a data segment?

1064

Explain the dml?

974

Difference between oracle's plus (+) notation and ansi join notation?

1098

How can we delete duplicate rows in a table?

971

How to work with data objects interactively?

974

Whats the benefit of dbms_stats over analyze?

1997

What is a sub query? What are its various types?

1168

How to omit columns with default values in insert statement in oracle?

1044

How do I find my oracle client driver version?

1038