HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
- 3 Answers
- 9238 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mats önnerby
Set up an ODBC connection with the database.
Then from Excel menu, select Data => Import external data
=> New database query. From there it is intuitive.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / ron
don't have a simple answer, you'll need to use oracle utils,
util_file and packages:
read about it in detail to download and running package at
website below:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:728625409049
hope this helps.
| Is This Answer Correct ? | 0 Yes | 2 No |
waht is referencial integrity?
How to convert characters to times in oracle?
What is ADDM Advisor in Oracle?
What are the set operators union, union all, minus & intersect meant to do?
What is enter substitution variable in oracle?
what is Single Byte Overhead...?
Explain compound trigger in oracle?
What is using clause and give example?
How to count groups returned with the group by clause in oracle?
Can objects of the same schema reside in different tablespace?
Which environment variables are absolutely critical in order to run the OUI?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
Oracle General 
