How Do I Generate HTML Output from PL/SQL? :
This POST introduces an additional method, PL/SQL server pages,
that lets you build on your knowledge of HTML tags, rather than
learning a new set of function calls.
Traditionally, PL/SQL web applications have used function calls to
generate each HTML tag for output, using the PL/SQL web toolkit packages
that come with Oracle9i Application Server (iAS), Oracle Application Server
(OAS), and WebDB:
owa_util.mime_header('text/html');
htp.htmlOpen;
htp.headOpen;
htp.title('Title of the HTML File');
htp.headClose;
htp.bodyOpen( cattributes => 'TEXT="#000000" BGCOLOR="#FFFFFF"');
htp.header(1, 'Heading in the HTML File');
htp.para;
htp.print('Some text in the HTML file.');
htp.bodyClose;
htp.htmlClose;
You can learn the API calls corresponding to each tag, or just use some
of the basic ones like HTP.PRINT to print the text and tags together:
htp.print('<html>');
htp.print('<head>');
htp.print('<meta http-equiv="Content-Type" content="text/html">');
htp.print('<title>Title of the HTML File</title>');
htp.print('</head>');
htp.print('<body TEXT="#000000" BGCOLOR="#FFFFFF">');
htp.print('<h1>Heading in the HTML File</h1>');
htp.print('<p>Some text in the HTML file.');
htp.print('</body>');
htp.print('</html>');
Sql Server Interview Qus:
SQL Server questions for interview
Overview of Sql
Sql server while loop
Continue Statement in sql
SQL Parameter how to use in asp.net
SQL-QUERY TYPES, ALIASES, JOINS, CLAUSES, FUNCTIONS
Sql-determine the version and edition of SQL Server
Sql -Stored procedure how to use
Different Types of SQL Server Stored Procedures
SQL-Create Stored Procedure in SQL Server:
SQL Server -Create Stored Procedure with Parameter
How to Create Sql Function,
SQLInjection, prevent asp.net web application
SQL Server- Database Backup and Restore History
SQL Server -Create Stored Procedure with Parameter
Sql server cursor declaration syntax example
Sql server –Example of sql cursor with syntax
Drop all Triggers belonging to any schema in SQL Server.
SQL Server - Copy data from one database to another data base.
SQL Server bulk copy and bulk import and export techniques