HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
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 |
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
What is data block in Oracle?
"primary key=unique+null" is equal,reson?not,reason?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to handle a single quote in oracle sql?
What privilege is needed for a user to create indexes in oracle?
What is an Index ?
How to create a new table in oracle?
How to assign data of the deleted row to variables?
What is an oracle tablespace?
What is key preserved table?