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

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

2 Answers
3058 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / prabhudatta barick

--CREATE A OBJECT TO HOLD ADDRESS

CREATE OR REPLACE TYPE ADDRESSES AS
OBJECT(ADDRESS1 VARCHAR2(1000),
ADDRESS2 VARCHAR2(1000));

--CREATE TABLE
CREATE TABLE EMP (
EMPNO VARCHAR2 (5),
ENAME VARCHAR2 (30),
ADDR ADDRESSES);

--INSERT DATA
INSERT INTO EMP VALUES(0001,'PRABHUDATTA',ADDRESSES
('BANGALORE','KARNATAKA'));

COMMIT;

--SELECT DATA
SELECT EMPNO, ENAME,A.ADDR.ADDRESS1,A.ADDR.ADDRESS2 FROM
EMP A;

Is This Answer Correct ?

3 Yes

1 No

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

Answer / sudipta santra

Yes you can. Just use the nested table concept . Then u can
make another table under the column Address. For a
particular row one address value can also hold the multiple
value for addr1 and addr2.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer