Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
- 3 Answers
- 10566 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 is the fastest query method to fetch data from the table?
What are the types of synonyms?
How to export data with a field delimiter?
How to test null values?
how to handle exceptions in post production
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What is the use of Control File ?
What is the usage of control file in oracle?
please explain.. DB architecture ...
What is system global area (sga) in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is a dead lock in oracle?
Oracle General 
