Well Jeff, I'm just trying to run this cool script to export to an Excel file.
Someone said it works fine in SQL *Plus.
However, apparently SQL Developer doesn't support SET MARKUP HTML.
SET LINESIZE 4000
SET VERIFY OFF
SET FEEDBACK OFF
SET PAGESIZE 99999
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
SET TERMOUT OFF ECHO OFF
-- SET MARKUP HTML ON TABLE ""
-- ENTMAP ON SPOOL ON PREFORMAT OFF
SELECT object_type ObjType
, SUBSTR( object_name, 1, 30 ) ObjectName
ORDER BY 1, 2
-- SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON
SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON
SET LINESIZE 2000 VERIFY ON FEEDBACK ON PAGESIZE 60 TERMOUT ON
To add to Jeff's comments...
1. Use SHOW ALL in the worksheet before running a new script to see the list of emulated / supported SQL*Plus SET options
2. To view a query in HTML format (but not quite as nice as the format your script exhibits) ...
a) Use the Reports view to create a User Defined Report script for your SELECT statement.
b) From the Reports navigator tree, right-click on the script and select the HTML... context menu option.
SQL Developer Team
Wow Gary - thanks for that !!!
It actually rendered beautifully with 2 small issues:
1) first 3 rows of the Excel worksheet were left blank (data started in Row #4)
2) It appears it attempted to style the rows odd-even with an alternating fill color...
however, only rows #1 and #2 rendered in that regard.
Rows #3 and beyond kept the same fill color as row #2.
Glad you like it, and I hope you can tweak it to solve the other issues. But my comment about
not quite as nice as the format your script exhibits
was comparing how the following two things render in Firefox...
1. The report HTML (using only the SELECT statement) option as I describe in my prior post.
2. Running your script in SQL*Plus after changing the output file extension from xls to html, then opening it in Firefox
So I'm a bit confused by your comments, but wish you all the best going forward.