Chapter 10: Generating Datagrams with PL/SQL
Example
Caption
Filename
10-1
Sample PL/SQL code block
PlsqlBlock.sql
10-2
PL/SQL Hello World
HelloWorld.sql
10-3
PL/SQL FOR loop
ForLoop.sql
10-4
PL/SQL FOR loop with a cursor
CursorForLoop.sql
10-5
PL/SQL FOR loop with a cursor and bind variables
CursorForLoopWithVars.sql
10-6
PL/SQL procedure taking a parameter
FirstProcedure.sql
10-7
Procedure to return HTML page of stock quotes
StockQuotesHtml.sql
10-8
Procedure to return XML stock quote datagram
StockQuotesXml.sql
10-9
Helper package to simplify XML creation
XmlHelper.sql
10-10
Improved procedure returning XML stock quotes
StockQuotesXmlUsingHelper.sql
10-11
Automatically producing stock quote XML with DBXML
StockQuotesDbxmlBasic.sql
10-12
XML stock portfolio using DBXML
StockQuotesDbxml.sql
10-13
Multi-table patient profile with DBXML
PatientProfile.sql
10-14
Nested DBXML query results for the patient table
PatientProfile.xml
10-15
Multi-table state profile with DBXML
StateProfile.sql
10-16
Nested DBXML query results for the state table
StateProfile.xml