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






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. HTP
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