how to I convert data from oracle database into excel sheet.
I need to export columns and there datas from oracle database to microsoft excel sheet.
Please let me know the different ways for doing this.
The easiest way would be to do it right from excel using an external query (Database menu).
Failing that, you can run a query is SQL*Plus that will spool out comma delimited text that you can then open in Excel as a .CSV file:
select cola||','||colb||','||colc ...
try something like this:
you might have to work this one because i created a view.
SET LINESIZE 1000 VERIFY OFF FEEDBACK OFF SPOOL ON PREFORMAT OFF
COLUMN FIRSTNAME FORMAT A15
COLUMN LASTNAME FORMAT A25
--SPOOL C:\Documents and Settings\Lorenzo Harris Sr\Application Data\Microsoft
create OR REPLACE view ADDRESS_1 as
SELECT DISTINCT *
--SET SPOOL OFF PREFORMAT ON
--SET LINESIZE 80 VERIFY ON FEEDBACK ON
HOST START excel.exe "C:\Documents and Settings\Lorenzo Harris Sr\Application Data\Microsoft\Queries\query from HARRIS.dqy"