Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SET MARKUP HTML fails

SyswizardMar 27 2014 — edited Mar 28 2014

Sorry to bring this up in this sub-forum, but the SQL-Plus forum is somewhat dead.

I am attempting to create an Excel file using HTML output.

However, SQL Plus constantly denies this statement:

line 8: SQLPLUS Command Skipped: set MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF

Apparently there are other settings needed to make this work.

Here is the entire script:

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

SPOOL C:\temp\test_xls.xls

SELECT    object_type ObjType   

,         SUBSTR( object_name, 1, 30 ) ObjectName

,         created        

,         last_ddl_time  

,         status        

FROM      user_objects

ORDER BY  1, 2

;

SPOOL OFF

-- 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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 25 2014
Added on Mar 27 2014
10 comments
1,399 views