HTP.PRINT with to_char method : HTP « System Packages « Oracle PL/SQL Tutorial

SQL>
SQL> CREATE OR REPLACE PROCEDURE hockey_pass (p_person_txt IN VARCHAR2) IS lv_assists_num PLS_INTEGER;
  2  BEGIN
  3     SELECT 1 INTO   lv_assists_num FROM dual;
  4     HTP.PRINT(p_person_txt || ' has ' || to_char(lv_assists_num) || ' assists this season');
  5  END hockey_pass;
  6  /

Procedure created.

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