Hi,
I want table structure shown below. How can i create this ?
Num Name Address
Addr1 Addr2
I want Addr1 and Addr2 under Address column.
How can i achive this ? Is it possible ?
Answer Posted / begum
hi this is really work
create type addr as object (
add1 varchar2(15),
add2 varchar2(15));
/
create table nest1 (
id number(2),
name varchar2(10),
address addr);
insert into nest1 values(10,'uma',addr('10th
main','bangalore'));
/
insert into nest1 values(20,'sami',addr('77g
colony','chennai'));
SQL> select * from nest1;
ID NAME
---------- ----------
ADDRESS(ADD1, ADD2)
--------------------------------------------
10 uma
ADDR('10th main', 'bangalore')
20 sami
ADDR('77g colony', 'chennai')
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is PL/SQL ?
Give the advantages and disadvantages of clusters.
What are the differences between date and timestamp in oracle?
What are the limitations of check constraint?
Can I create users through internet explorer in oracle 10g?
What is Virtual Private Database in Oracle?
Can we create database in oracle using command line ?
What is oracle used for?
What exactly do quotation marks around the table name do?
How do I uninstall oracle client from windows?
Why use resource manager in Oracle?
Query to retrieve record for a many to many relationship ?
Which is faster join or subquery in oracle?
What is the difference between post-database commit and post-form commit?