create table emp(num number(5),name varchar2(14),address varchar2(15)); i

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

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2260

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

983

How to get a list of all user accounts in the database?

1038

How to run the anonymous block again?

1072

How to define an anonymous block?

1089

What is a trigger oracle?

1045

What is the usage of control file in oracle?

1034

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1884

What is instant client oracle?

979

What is java oracle used for?

981

Explain the truncate in oracle?

921

What is an oracle table?

938

How different is ms access and oracle?

992

How to execute a stored procedure in oracle?

1039

Explain joins in oracle?

987