Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
- 3 Answers
- 10706 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 |
11. Display the client number and name and the client number and name of the person who referred that client.
What are the different types of record groups in oracle? Explain each of them
How to check database size in Oracle?
What is meant by joins?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
What is Read-Only Transaction ?
What do you understand by database schema and what does it hold?
In which language oracle has been developed?
Describe varray?
How to check the server version in oracle?
Describe Referential Integrity ?
What privilege is needed for a user to create views in oracle?
Oracle General 
