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 an oracle database?
What is the database name in oracle?
What is oracle in java?
Can a parameter be passed to a cursor?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What operating systems are supported by oracle database 10g xe?
How to see the table columns used in an index?
Explain the use of Merge statement in oracle 11g
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
How to load a large xml file?
How to use "in out" parameter properly?
How to connect to oracle using service name instead of sid?