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
4040 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 coalesce function?

630

How many types of tables are there in oracle?

577

Can we create trigger on materialized view in oracle?

567

Explain what are the type of synonyms?

582

How to connect ms access to oracle servers?

552

What is system global area (sga) in oracle?

576

How to use values from other tables in update statements using oracle?

568

How to export data to a csv file?

627

What are the most common interview questions on ETL Testing for experience?

599

What is analyze command used for?

582

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1658

Explain parameter file in oracle.

580

What are the arithmetic operations?

590

Explain the use of ignore option in imp command.

577

How to write a left outer join with the where clause in oracle?

631