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

Explain a synonym?

1020

What is partitioned table in Oracle?

1180

what are archived logs?

2192

What is hot backup and logical backup?

1045

How do I reset a sequence in oracle?

1092

Is postgres faster than oracle?

1016

How to retrieve values from data fields in record variables?

1104

What is the Tune Query

2286

What is a static data dictionary in oracle?

1101

What is the usage of save points in oracle database?

959

How to run create database statement?

1023

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2617

What is SQL Tuning Advisor in Oracle?

1167

How to define a sub function?

1122

What is using clause and give example?

1027