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 |
What is hash cluster in oracle?
What are the types of trigger in oracle?
How do I connect to oracle database?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
What is an Oracle view?
What are the components of Logical database structure of ORACLE database?
what is the difference between substr and instr function in oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
How to check the server version in oracle?
What is the best way to do multi-row insert in oracle?
How to use subqueries with the in operator using oracle?
how to unbreak sequence numbers during intereptions