This section shows the XML representation of selected columns of the titles table.
set stringsize 16384 select text_doc from sample_docs where name_doc='titles' text_doc ---------------------------------------------------- <titles xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”> <row> <title_id>BU1032<title_id> <title>The Busy Executive’s Data Base Guide</title> <type>business</type> <pub_id>1389</pub_id> <price>19.99</price> <advance>5000.00</advance> <total_sales>4095</total_sales> </row> <row> <title_id>BU1111</title_id> <title>Cooking with Computers: Surreptitious Balance Sheets</title> <type>business </type> <pub_id>1389</pib_id> <price>11.95</price> <advance>5000.00</advance> <total_sales>3876</total_sales> </row> <row> <title_id>BU2075</title_id> <title>You Can Combat Computer Stress!</title> <type>business </type> <pub_id>0736</pub_id> <price>2.99</price> <advance>10125.00</advance> <total_sales>18722</total_sales> </row> <row> <title_id>BU7832</title_id> <title>Straight Talk About Computers</title> <type>business </type> <pub_id>1389</pub_id> <price>19.99</price> <advance>5000.00</advance> <total_sales>4095</total_sales> </row> <row> <title_id>MC2222</title_id> <title>Silicon Valley Gastronomic Treats</title> <type>mod_cook</type> <pub_id>0877</pub_id> <price>19.99</price> <advance>0</advance> <total_sales>2032</total_sales> </row> <row> <title_id>MC3021</title_id> <title>The Gourmet Microwave</title> <type>mod_cook</type> <pub_id>0877</pub_id> <price>2.99</price> <advance>15000.00</advance> <total_sales>22246</total_sales> </row> <row> <title_id>MC3026</title_id> <title>The Psychology of Computer Cooking</title> <type>UNDECIDED</type> <pub_id>0877</pub_id> </row> <row> <title_id>PC1035</title_id> <title>But Is IT User Friendly?</title> <type>popular_comp</type> <pub_id>1389</pub_id> <price>22.99</price> <advance>7000.00</advance> <total_sales>8780</total_sales> </row> <row> <title_id>PC8888</title_id> <title>Secrets of Silicon Valley</title> <type>popular_comp</type> <pub_id>1389</pub_id> <price>20.00</price> <advance>8000.00</advance> <total_sales>4095</total_sales> </row> <row> <title_id>PC9999</title_id> <title>Net Etiquette</title> <type>popular_comp</type> <pub_id>1389</pub_id> </row> <row> <title_id>PS1372</title_id> <title>Computer Phobic and Non-Phobic Individuals: Behavior Variations</title> <type>psychology </type> <pub_id>0877</pub_id> <price>21.59</price> <advance>7000.00</advance> <total_sales>375</total_sales> </row> <row> <title_id>PS2091</title_id> <title>Is Anger the Enemy?</title> <type>psychology </type> <pub_id>0736</pub_id> <price>10.95</price> <advance>2275.00</advance> <total_sales>2045</total_sales> </row> <row> <title_id>PS2106</title_id> <title>Life Without Fear</title> <type>psychology </type> <pub_id>0736</pub_id> <price>7.99</price> <advance>6000.00</advance> <total_sales>111</total_sales> </row> <row> <title_id>PS3333</title_id> <title>Prolonged Data Deprivation: Four Case Studies</title> <type>psychology</type> <pub_id>0736</pub_id> <price>19.99</price> <advance>2000.00</advance> <total_sales>4072</total_sales> </row> <row> <title_id>PS7777</title_id> <title>Emotional Security: A New Algorithm</title> <type>psychology </type> <pub_id>0736</pub_id> <price>7.99</price> <advance>4000.00</advance> <total_sales>3336</total_sales> </row> <row> <title_id>TC3218</title_id> <title>Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean</title> <type>trad_cook </type> <pub_id>0877</pub_id> <price>20.95</price> <advance>7000.00</advance> <total_sales>375</total_sales> </row> <row> <title_id>TC4203</title_id> <title>Fifty Years in Buckingham Palace Kitchens</title> <type>trad_cook </type> <pub_id>0877</pub_id> <price>11.95</price> <advance>4000.00</advance> <total_sales>15096</total_sales> </row> <row> <title_id>TC7777</title_id> <title>Sushi, Anyone?</title> <type>trad_cook </type> <pub_id>0877</pub_id> <price>14.99</price> <advance>8000.00</advance> <total_sales>4095</total_sales> </row> </titles> (1 row affected)
