oracle plsql index_by表 clear,在Oracle ERP中使用PLSQL 结合HTML 写报表.pdf

ERP REPORT

PL/SQL 结合HTML 写报表

作者：Team

在 ORACLE ERP 里面，大家都很习惯用 REPORT BUILDER 来写报表，REPORT

BUILDER 写出来的报表上挂到用系统里面，然后提交后台请求输出报表；我这里介绍另

外一种比较方便的写报表的方式，整个报表是用FORM 、PL/SQL 结合HTML 语言来写；

我们知道ORACLE 数据库提供一个包叫HTP ，专门是用于写网页报表的；我们这里也将

要用到；

这个包里面有一些组件：

htp.print

语法 htp.print (cbuf | dbuf | nbuf);

作用 generates a line in an HTML document.

参数 cbuf in varchar2 or

dbuf in date or

nbuf in number

Generates Generates a line in an HTML document based on the value passed to it.

htp.p

Alias for htp.print

Structure Tags 结构标记

The following tags are used to identify the major parts of an HTML

document.

Note : Although this section shows hypertext procedures (HTP), all of

them are also available as hypertext functions (HTF).

htp.htmlOpen

语法 htp.htmlOpen;

作用 Prints a tag that indicates the beginning of an HTML document

ERP REPORT

参数 none

Generates

htp.htmlClose

语法 htp.htmlClose;

作用 Prints a tag that indicates the end of an HTML document

参数 none

Generates

htp.headOpen

语法 htp.headOpen;

作用 Prints a tag that indicates the beginning of the HTML document head

参数 none

Generates

htp.headClose

语法 htp.headClose;

作用 Prints a tag that indicates the end of the HTML document head

参数 none

Generates

htp.bodyOpen

语法 htp.bodyOpen (cbackground, cattributes);

作用 Prints the tag that identifies the beginning of the body of an HTML document, and

allows you to specify an image as the background of the document

参数 cbackground in varchar2 DEFAULT NULL

cattributes in varchar2 DEFAULT NULL

Generates

Note : If