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
3037 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

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,

What is the exact use of Collections?

0 Answers

Explain an exception?

0 Answers

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers TCS,

what is kernel?

2 Answers Microsoft,

Can u make a synonym for deptno=10 only from emp table.

1 Answers TCS,

Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers

How to define an anonymous procedure without variables?

0 Answers

interview questions with answer for cts

0 Answers Cognizant,

What is a nvl function? How can it be used?