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

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

How to drop an index?

1013

Briefly explain what is literal? Give an example where it can be used?

1087

How to create a new table in oracle?

1231

Can group functions be mixed with non-group selection fields?

1073

How do you bind variables in oracle?

1021

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2077

Explain oracle’s server parameter file.

1040

How to define an anonymous procedure with variables?

1238

What is oracle join syntax?

1061

How to drop an index in oracle?

1119

What is a tns service name?

1056

What are dml statements in oracle?

1130

What is an oracle table?

1031

what is IDE,DMV in sql server?

2878