{"id":8,"date":"2009-03-27T15:10:49","date_gmt":"2009-03-27T14:10:49","guid":{"rendered":"http:\/\/hslomka.de\/techno\/?p=8"},"modified":"2009-03-27T15:10:49","modified_gmt":"2009-03-27T14:10:49","slug":"mit-sql-direkt-html-dateien-erzeugen","status":"publish","type":"post","link":"https:\/\/techno.slomka.biz\/?p=8","title":{"rendered":"Mit SQLPLUS direkt HTML Dateien erzeugen"},"content":{"rendered":"

Seit Oracle 8i gibt es eine elegante Methode mit SQL*Plus direkt HTML Code zu erzeugen. Dazu wird die HTML Ausgabe mit<\/p>\n

SET MARKUP HTML ON<\/code><\/p>\n

aktiviert. Deaktiviert wird die HTML Ausgabe mit:<\/p>\n

SET MARKUP HTML OFF SPOOL OFF<\/code><\/p>\n

SQL Statement<\/strong>
\nDieses Beispiel gibt das SQL Statement show user<\/i> als HTML Datei \/tmp\/ts_size.htm<\/i> aus.<\/p>\n

<\/code><\/p>\n

SET MARKUP HTML ON SPOOL ON –
\nHEAD “<title>SQL*Plus Report<\/title> –
\n<STYLE TYPE=’TEXT\/CSS’> –
\n<!–BODY {background: ffffc6} –> –
\n<\/STYLE>”
\nBODY “TEXT=’#FF00Ff'” –
\nTABLE “WIDTH=’90%’ BORDER=’5′”
\n 
\nSET ECHO OFF
\nSPOOL \/tmp\/ts_size.htm
\n 
\nshow user;
\n 
\nSPOOL OFF
\nSET MARKUP HTML OFF
\nSET ECHO ON<\/p>\n<\/p>\n

Details verr\u00e4t die Oracle Dokumentation: Generating HTML Reports from SQL*Plus<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Seit Oracle 8i gibt es eine elegante Methode mit SQL*Plus direkt HTML Code zu erzeugen. Dazu wird die HTML Ausgabe mit SET MARKUP HTML ON aktiviert. Deaktiviert wird die HTML Ausgabe mit: SET MARKUP HTML OFF SPOOL OFF SQL Statement Dieses Beispiel gibt das SQL Statement show user als HTML Datei \/tmp\/ts_size.htm aus. SET MARKUP HTML ON SPOOL ON – HEAD “<title>SQL*Plus Report<\/title> – <STYLE TYPE=’TEXT\/CSS’> – <!–BODY {background: ffffc6} –> – <\/STYLE>” BODY “TEXT=’#FF00Ff’” – TABLE “WIDTH=’90%’ BORDER=’5′”   SET ECHO OFF SPOOL \/tmp\/ts_size.htm   show user;   SPOOL OFF SET MARKUP HTML OFF SET ECHO ON Details verr\u00e4t die Oracle Dokumentation: Generating HTML Reports from SQL*Plus<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13],"tags":[66,76,86,92,93],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-oracle","category-oracle-datenbank","tag-html","tag-oracle","tag-script","tag-sql","tag-sqlplus"],"_links":{"self":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts\/8","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8"}],"version-history":[{"count":0,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts\/8\/revisions"}],"wp:attachment":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}