In SQL Prompt: ------------- set lines 100 pages 100; set colsep"|&

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

Question Posted / karthik

3 Answers
10707 Views
I also Faced
E-Mail Answers

Answer Posted / karthik

In SQL Prompt:
-------------
set lines 100 pages 100;
set colsep"|"
spool c:\Datas.xls;
select * from emp
/
spool off;

In Excel Sheet, use Text to Column->Delimeter to replace
the "|" pipe symbol

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between restoring and recovering?

1053

Why do we use bulk collect in oracle?

1105

What is PL/SQL ?

2220

What is clustered table in Oracle?

1260

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1092

What is the difference between $oracle_base and $oracle_home?

1136

What is null value in oracle?

1157

What is ordinary table in oracle?

1238

How to use in conditions in oracle?

1115

Write a syntax for update query in oracle?

1073

what is the difference between substr and instr function in oracle?

1143

Explain overloading. Can functions be overloaded?

1046

How to install oracle database 10g xe?

1064

how can we store any pdf file in oracle

2220

What is oracle database client?

1081