Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 5050 Views
- IBM, I also Faced
- E-Mail Answers
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
Difference between cartesian join and cross join?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the difference between 10g OEM and 11g OEM?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Differentiate between pre-select and pre-query?
How a tablespace is related to data files?
How to increment dates by 1 in oracle?
Is there a combination of "like" and "in" in sql?
how to do daily transactions with out sql* loader control file regesterd in apps?
what is the dual table in oracle?
how to make an oracle object
How to assign data of the deleted row to variables?
How to run create database statement?
When system tablespace is created?
How to rename an existing table?
