Hi, I want table structure shown below. How can i create this ? Num Name Ad

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 ?

Question Posted / manojkumar

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

Answers were Sorted based on User's Feedback

Hi, I want table structure shown below. How can i create this ? Num Name Address Add..

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

Hi, I want table structure shown below. How can i create this ? Num Name Address Add..

Answer / ashok

create table emp(num number(5),name varchar2(14),address
varchar2(15));
insert into emp values('&num','&name','&address');
Enter value for num:
Enter value for name:
Enter value for address: addr1 addr2
old 1: insert into emp values('&num','&name','&address')
new 1: insert into emp values('','','addr1 addr2')

Is This Answer Correct ?

1 Yes

12 No

Post New Answer