SET PAGESIZE 50000
SET FEEDBACK OFF
SET MARKUP HTML ON SPOOL ON
SET NUM 24
SPOOL example.xls
Run the query.
SPOOL OFF
SET MARKUP HTML OFF SPOOL OFF
Example:
SET PAGESIZE 50000
SET FEED OFF MARKUP HTML ON SPOOL ON
SET NUM 24
SPOOL online_accouting.xls
select * from fnd_log_messages where log_sequence between 35644336 and 35644404;
SPOOL OFF
SET MARKUP HTML OFF SPOOL OFF
ReplyDeleteExcel is a software program from Microsoft basic excel for beginners that is a part of Microsoft Office. Excel calculations is compiled for making and altering spreadsheets that are spared with a .xls expansion. It's general uses in corporate cell-based figuring, turn tables, and different diagramming devices. With an Excel spreadsheet, you could make a month to month spending plan, track costs of doing business, or sort and compose a lot of information calculations in spreadsheets of Excels.