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
5037 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

What are the built-in functions used for sending Parameters to forms ?

3390

What is the difference between post-database commit and post-form commit?

1204

Why do we need oracle client?

956

How to use fetch statement in a loop?

1021

What is ordinary table in oracle?

1159

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

Explain the use of record length option in exp command.

1067

What is Reduced List of Values?

2170

What is an oracle database table?

1017

What is the parameter mode that can be passed to a procedure?

1052

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2358

What is recycle bin in Oracle?

1153

What is the difference between view and materialized view in Oracle?

1156

How to lock and unlock a user account in oracle?

1108

How do I know if oracle client is installed on windows?

1024