HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle?
How to use subqueries with the in operator using oracle?
What exactly do quotation marks around the table name do?
What is a relational database management system?
What is the fastest query method to fetch data from the table?
What is the best way to do multi-row insert in oracle?
What is oracle host variable?
How to create a table in a specific tablespace?
What are a query and state the different types of queries and their uses?
Which is better Oracle or MS SQL? Why?
What is a package in oracle?
What happens if the imported table already exists?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What are the parameters that we can pass through a stored procedure?
What is a named program unit?