Chapter 10: Generating Datagrams with PL/SQL

ExampleCaptionFilename
10-1Sample PL/SQL code blockPlsqlBlock.sql
10-2PL/SQL Hello WorldHelloWorld.sql
10-3PL/SQL FOR loopForLoop.sql
10-4PL/SQL FOR loop with a cursorCursorForLoop.sql
10-5PL/SQL FOR loop with a cursor and bind variablesCursorForLoopWithVars.sql
10-6PL/SQL procedure taking a parameterFirstProcedure.sql
10-7Procedure to return HTML page of stock quotesStockQuotesHtml.sql
10-8Procedure to return XML stock quote datagramStockQuotesXml.sql
10-9Helper package to simplify XML creationXmlHelper.sql
10-10Improved procedure returning XML stock quotesStockQuotesXmlUsingHelper.sql
10-11Automatically producing stock quote XML with DBXMLStockQuotesDbxmlBasic.sql
10-12XML stock portfolio using DBXMLStockQuotesDbxml.sql
10-13Multi-table patient profile with DBXMLPatientProfile.sql
10-14Nested DBXML query results for the patient tablePatientProfile.xml
10-15Multi-table state profile with DBXMLStateProfile.sql
10-16Nested DBXML query results for the state tableStateProfile.xml