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 |
Is there a function to split a string in plsql?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Differentiate between pre-select and pre-query?
How to resolve name conflicts between variables and columns?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is backup in Oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What are the different types of modules in oracle forms?
What is a trigger and what are its types?
What is an oracle transaction?
In Oracle 9i what does "i" Stands for?
After using set unused can we enable the column again to use? Please give me some answers....