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 |
What is the maximum number of triggers that can be applied to a single table?
What is oracle database 10g express edition?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
How to pass a cursor variable to a procedure?
Difference between varchar and varchar2 data types?
How to delete multiple rows from a table in oracle?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
how to get the index id?
How to use group functions in the select clause using oracle?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
How to create tables for odbc connection testing?
Explain the use of show option in imp command.