用Oracle的SQL工具创建HTML页面(原)

yjm1976 · 发表于 2003-5-28 09:41

不错，是不是底版本的也可以呢

willians · 发表于 2003-5-28 10:17

其實大家可以試試owa_util 這個package就可以直接做到了！特別是在isqlplus 而且也可以利用在
Oracle的psp(PL/SQL Server Pages )很好用的。
ex :
begin
dummy boolean;
being
dummy:=owa_util.tableprint('employee','border');
end;
/
然後再利用owa_util.showpage()印出來就可以了！

jerry · 发表于 2003-5-29 10:07

這是我在一個國外的網站上看到的
大家可以參考參考

SQL*Plus is primarily a character mode terminal application. However, since version 8.1.6, SQL*Plus has the ability to format its output in HTML format. To enable HTML output, use the command:

SQL> set markup html on

After it's turned on, several characters, such as >, <, and & are automatically changed to HTML entities. You can disable this feature by adding the option ENTMAP OFF.

SQL> set markup html entmap off;
SQL>

When you issue a query, the results will be generated as an HTML TABLE, TR, and TD instead of as the usual formatted ASCII output:

SQL> select sysdate from dual;
<br>
<p>
<table border="1" width="90%">
<tr>
<th>
SYSDATE
</th>
</tr>
<tr>
<td>
30-MAR-03
</td>
</tr>
</table>
<p>

If you want to see the results as a preformatted HTML PRE element, use the option PREFORMAT ON:

SQL> set markup html preformat on;
SQL> select sysdate from dual;
<br>
<pre>

SYSDATE
---------
30-MAR-03
</pre>

If you specify SPOOL ON, SQL*Plus will generate headers to the spool file when you issue the SPOOL command.

You can change the HEAD tag contents, BODY tag, and TABLE tag attributes in the output by specifying those tag names as options:

SQL> set markup html head '<style type="text/css">body {background: white}</style>' -
> body 'bgcolor="#FFFFFF"' -
> table 'width="100%" border=0'
SQL> select sysdate from dual;
<br>
<p>
<table width="100%" border=0>
<tr>
<th>
SYSDATE
</th>
</tr>
<tr>
<td>
30-MAR-03
</td>
</tr>
</table>
<p>

With MARKUP HTML ON enabled, the PAGESIZE, LINESIZE, TTITLE, BTITLE, and COLUMN commands are reflected in the HTML output.

You can enable MARKUP HTML commands and options from the command line, like this:

REM -- report.sql
select * from emp order by empno;
exit;

sqlplus -s -m "html on" scott/tiger @report > report.html

Using this method, you can run an old character mode SQL*Plus report and generate HTML without modifying the script.