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

How oracle handles dead locks?

1017

State and explain about oracle instance?

928

What is a snapshot log?

949

What is a system tablespace?

1004

What is a table in oracle?

925

How to drop a stored procedure in oracle?

995

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

978

What are the advantages of oracle 12c?

1118

Explain mutating triggers.

972

Explain how you would restore a database using RMAN to Point in Time?

2093

What are the types of partitions in oracle?

973

State and explain the different types of data models?

893

Explain the use of indexes option in imp command.

1084

What is the sql query to concatenate column values from multiple rows in oracle?

995

What is procedure overloading in oracle?

991