Re: generate html report using sqlplus

Using sqlplus, and if u have access to the htp and htf package, it should be no problem generating HTML, for example, look at the file $ORACLE_HOME/rdbms/admin/privutil.sql, and search for all the htp.* function usage, and u can get the idea how it uses htp functions to generate HTML structure contents.

For example:

     htp.preOpen;
         htp.prints(translate(text,NL_CHAR,' '));
      htp.preClose;

And this:

         htp.print('</PRE>');
           htp.p(htf.format_cell(columnValue, format_numbers));
                    htp.tableRowOpen;
                    htp.tableRowClose;
               htp.tableRowOpen;
               htp.tableRowClose;
            htp.formSelectOpen( cname => p_cname,
                  htp.formSelectOption( cvalue => nc_visible,
            htp.formSelectClose;

etc. Received on Thu Jan 17 2008 - 22:53:21 CST