--CREATE A OBJECT TO HOLD ADDRESS CREATE OR REPLACE TYPE ADDRESSES AS

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 / prabhudatta barick

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to divide query output into groups in oracle?

942

how to clone 9i Database on to 10g Database.

2284

What do you mean by group by clause?

977

How can Oracle users be audited?

1052

How to name query output columns in oracle?

1129

How to resolve the ORA-39133 error in Oracle?

1029

How to use "in out" parameter properly?

997

What are the system predefined user roles?

981

What is dynamic proxy?

958

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2410

What is tns entry?

1058

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

1025

How to write date and time interval literals in oracle?

963

Explain implicit cursor.

957

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2314