This content has been marked as final. Show 3 replies
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 ...
Can oracle Reports Designer be used to export oracle data into excel sheet ??
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"