Using HTP.PRINT and HTF.BR to output a HTML : HTP « System Packages « Oracle PL/SQL Tutorial

1.	Introduction
2.	Query Select
3.	Set
4.	Insert Update Delete
5.	Sequences
6.	Table
7.	Table Joins
8.	View
9.	Index
10.	SQL Data Types
11.	Character String Functions
12.	Aggregate Functions
13.	Date Timestamp Functions
14.	Numerical Math Functions
15.	Conversion Functions
16.	Analytical Functions
17.	Miscellaneous Functions
18.	Regular Expressions Functions
19.	Statistical Functions
20.	Linear Regression Functions
21.	PL SQL Data Types
22.	PL SQL Statements
23.	PL SQL Operators
24.	PL SQL Programming
25.	Cursor
26.	Collections
27.	Function Procedure Packages
28.	Trigger
29.	SQL PLUS Session Environment
30.	System Tables Data Dictionary
31.	System Packages
32.	Object Oriented
33.	XML
34.	Large Objects
35.	Transaction
36.	User Privilege

Oracle PL/SQL Tutorial » System Packages » HTP

31.37.5.Using HTP.PRINT and HTF.BR to output a HTML

SQL>

SQL>

SQL> CREATE OR REPLACE PROCEDURE showvals

  2     (p_a_txt IN VARCHAR2 DEFAULT NULL,

  3      p_b_txt IN VARCHAR2 DEFAULT NULL) IS

  4  BEGIN

  5     HTP.PRINT('a = '|| p_a_txt || HTF.BR);

  6     HTP.PRINT('b = '|| p_b_txt || HTF.BR);

  7  END showvals;

  8  /



Procedure created.



SQL>

31.37.HTP
	31.37.1.	Create HTML List tags
	31.37.2.	Display table names in user_tables in HTML format with HTP.PRINT
	31.37.3.	Use HTP package to create HTML page structure
	31.37.4.	HTP.PRINT with to_char method
	31.37.5.	Using HTP.PRINT and HTF.BR to output a HTML
	31.37.6.	Build query form with HTP
	31.37.7.	Display employee in HTML format using HTP package
	31.37.8.	Output a html table
	31.37.9.	Display records in a HTML table
	31.37.10.	Display records in a HTML table with parameters
	31.37.11.	output a form with action

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.