Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
- 3 Answers
- 10608 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 |
What are the limitations of check constraint?
What are the components of Logical database structure of ORACLE database?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How can we find out the duplicate values in an oracle table?
What is the recommended interval at which to run statspack snapshots, and why?
How to create an oracle database?
How many types of table in Oracle?
What is a synonym? What are its various types?
What is a cluster?
Is there any function in oracle similar like group_concat of mysql?
What is a package in oracle?
Oracle General 
