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.
Answers were Sorted based on User's Feedback
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 |
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 |
How to define a data source name (dsn) in odbc manager?
What is the use of Redo Log Information ?
How to bring a tablespace online?
What is the usage of merge statement?
How oracle handles dead locks?
What are the advantages of Views ?
What is literal?
What are named parameters?
Can a Tablespace hold objects from different Schemes ?
How to rename a column in an existing table?
What is meant by recursive hints ?
What is the quickest way to fetch the data from a table?