/
2443.html
1153 lines (1144 loc) · 71.7 KB
/
2443.html
1
<html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:w="urn:schemas-microsoft-com:office:word"xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Titlecontent="Errata for 582-3 Asleson (corrected in the second printing)"><meta name=Keywords content=""><meta http-equiv=Content-Type content="text/html; charset=macintosh"><meta name=ProgId content=Word.Document><meta name=Generator content="Microsoft Word 11"><meta name=Originator content="Microsoft Word 11"><link rel=File-List href="383-9%20Kothuri_files/filelist.xml"><title>Errata for 582-3 Asleson (corrected in the second printing)</title><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>Richard Ables</o:Author> <o:Template>Normal</o:Template> <o:LastAuthor>Richard Ables</o:LastAuthor> <o:Revision>2</o:Revision> <o:Created>2005-11-10T00:00:00Z</o:Created> <o:LastSaved>2005-11-10T00:00:00Z</o:LastSaved> <o:Pages>1</o:Pages> <o:Words>807</o:Words> <o:Characters>4603</o:Characters> <o:Lines>38</o:Lines> <o:Paragraphs>9</o:Paragraphs> <o:CharactersWithSpaces>5652</o:CharactersWithSpaces> <o:Version>11.0</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings></xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:Zoom>125</w:Zoom> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>0</w:DisplayVerticalDrawingGridEvery> <w:UseMarginsForDrawingGridOrigin/> </w:WordDocument></xml><![endif]--><style><!-- /* Font Definitions */@font-face {font-family:"Times New Roman"; panose-1:0 2 2 6 3 5 4 5 2 3; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:Verdana; panose-1:0 2 11 6 4 3 5 4 4 2; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:Verdana-Bold; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:Verdana; mso-font-charset:77; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:auto; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:TheSansMonoCondensed-Bold; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:"TheSansMonoCon-7 Bold"; mso-font-charset:77; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:auto; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:Utopia-Regular; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:Utopia; mso-font-charset:77; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:auto; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:TheSansMonoCondensed-SemiLight; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:"TheSansMonoCon-4 SemiLight"; mso-font-charset:77; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:auto; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:Bold; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:"Times New Roman"; mso-font-charset:77; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:auto; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:HelveticaNeue-BoldCond; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:"HelveticaNeue BoldCond"; mso-font-charset:77; mso-generic-font-family:swiss; mso-font-format:other; mso-font-pitch:auto; mso-font-signature:50331648 0 0 0 1 0;}@font-face {font-family:SemiLight; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:"Times New Roman"; mso-font-charset:77; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:auto; mso-font-signature:50331648 0 0 0 1 0;} /* Style Definitions */p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman";}table.MsoNormalTable {mso-style-parent:""; font-size:10.0pt; font-family:"Times New Roman";}@page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;}div.Section1 {page:Section1;}--></style></head><body bgcolor=white lang=EN-US style='tab-interval:.5in'><div class=Section1><p class=MsoNormal>Errata 383-9 Kothuri (corrected in the 2nd printing)<o:p></o:p></p><table border=1 cellspacing=0 cellpadding=0 width=599 style='width:599.4pt; border-collapse:collapse;border:none;mso-border-top-alt:solid gray 1.0pt; mso-border-left-alt:solid gray 1.0pt;mso-border-right-alt:solid gray 1.0pt; mso-padding-alt:0in 5.4pt 0in 5.4pt'> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-size:14.0pt; font-family:Verdana-Bold'><b>Page</b></span><span style='font-size:14.0pt; font-family:Verdana'><o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border:solid gray 1.0pt;border-left:none; mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-size:14.0pt; font-family:Verdana-Bold'><b>Original Sentence</b></span><span style='font-size:14.0pt;font-family:Verdana'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border:solid gray 1.0pt;border-left:none; mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-size:14.0pt; font-family:Verdana-Bold'><b>Corrected Sentence</b></span><span style='font-size:14.0pt;font-family:Verdana'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>24<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>For instance, the center of San Francisco is located at<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>coordinates (–122.436, –37.719) in the two-dimensional Òlatitude, longitudeÓ space.</span><span style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>For instance, the center of San Francisco is located at<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>coordinates (–122.436, 37.719) in the two-dimensional Òlatitude, longitudeÓ space.</span><span style='font-size:10.0pt;font-family:Verdana'><sub><o:p></o:p></sub></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>25<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>For example, you can insert a location of (–87, –78) for a Pizza Hut restaurant into the us_restaurants table as shown in Listing 2-2.<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>For example, you can insert a location of (–87, 38) for a Pizza Hut restaurant into the us_restaurants table as shown in Listing 2-2.<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>25<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Bold'><b>-78, -- second ordinate, i.e., value in latitude dimension</b></span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-Bold'><b>38, -- second ordinate, i.e., value in latitude dimension</b></span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>49<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>landsqmia<span style="mso-spacerun: yes"> </span>NUMBER,</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>landsqmi<span style="mso-spacerun: yes"> </span>NUMBER,</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>68<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SELECT a.location.sdo_gtype FROM us_states a WHERE state_abrv='NH';</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SELECT a.geom.sdo_gtype FROM us_states a WHERE state_abrv='NH';</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>68<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SELECT a.location.sdo_gtype FROM us_cities a WHERE state_abrv='TX';</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SELECT a.geom.sdo_gtype FROM us_cities a WHERE state_abrv='TX';</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>106<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>FIELDS TERMINATED BY '|'<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>TRAILING NULLCOLS</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>INTO TABLE sales_regions<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>APPEND<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>FIELDS TERMINATED BY '|'</span><span style='font-size:10.0pt;font-family:Utopia-Regular'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>107<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>INTO TABLE sales_regions<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>FIELDS TERMINATED BY '|'<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>INTO TABLE sales_regions<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>APPEND<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>FIELDS TERMINATED BY '|'<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>109<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>IMP scott/tiger FILE=customers.dmp IGNORE=Y INDEXES=N<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>IMP scott/tiger FILE=customers.dmp IGNORE=Y INDEXES=N TABLES=CUSTOMERS<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>110<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>EXP USERID = "'SYSTEM/MANAGER AS SYSDBA'" TRANSPORT_TABLESPACE=Y TABLESPACES=TBS<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>EXP USERID = "'SYS/<password>'" TRANSPORT_TABLESPACE=Y TABLESPACES=TBS<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>110<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>IMP USERID = "'SYSTEM/MANAGER AS SYSDBA'" TRANSPORT_TABLESPACE=Y FILE=trans_ts.dmp<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>IMP USERID = "'SYS/<password>'" TRANSPORT_TABLESPACE=Y FILE=trans_ts.dmp<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>111<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQLPLUS SYSTEM/MANAGER AS SYSDBA<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQLPLUS SYS/<password><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>112<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>CREATE TABLE customers<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>DROP TABLE customers;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>CREATE TABLE customers<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>114<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>xmltype(sdo_gml.to_gmlgeometry(geom)) as<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>xmltype(sdo_util.to_gmlgeometry(geom)) as<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>117<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>)<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>0.000005<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>)<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>),<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>0.000005<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>121<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SDO_UTIL.REMOVE_DUPLICATE_VERTICES(a.geom, 0.5)<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SDO_UTIL.REMOVE_DUPLICATE_VERTICES(a.geom, 0.5),<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>123<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>)<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>0.00005 -- tolerance<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>),<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>0.00005 -- tolerance<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>158<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SET SERVEROUTPUT ON<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SET SERVEROUTPUT ON SIZE 32000<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>161<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SET SERVEROUTPUT ON<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> SET SERVEROUTPUT ON SIZE 10000<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>163<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> ALTER TABLE competitors ADD (location SDO_GEOMETRY)<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> ALTER TABLE competitors ADD (location SDO_GEOMETRY);<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>187<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>DETERMINISTIC<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>RETURN SDO_GEOMETRY<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>RETURN SDO_GEOMETRY<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>DETERMINISTIC<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>195<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>END<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>/<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>END;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>/<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>230<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> DESCRIBE USER_SDO_GEOM_METDATA;<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> DESCRIBE USER_SDO_GEOM_METADATA;<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>269<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SELECT ct.id, ct.name, SDO_NN_DISTANCE(1) dist<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SELECT ct.id, ct.customer_grade, SDO_NN_DISTANCE(1) dist<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>275<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><b>Listing 8-53. </b></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><i>Setting Session Parameters to Enable Query Rewrite on Function-Based Indexes</i></span><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><b>Listing 8-53. </b></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><i>Setting Session Parameters to Enable Query Rewrite on Function-Based Indexes<o:p></o:p></i></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><i>(Not Necessary in Oracle 10g)</i></span><span style='font-size:10.0pt;font-family: TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>302<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>DECLARE<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>Geom mdsys.sdo_geometry<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>coverage mdsys.sdo_geometry := null;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>BEGIN<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>OPEN cur FOR SELECT geom FROM sales_regions;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>LOOP<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>EXIT WHEN cur%NOTFOUND;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>FETCH cur INTO geom;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>coverage := SDO_GEOM.SDO_UNION(coverage, geom);<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>END LOOP;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>EXECUTE IMMEDIATE 'INSERT INTO sales_region_coverage values (:1)'<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>USING coverage;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>COMMIT;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>END;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><![if !supportEmptyParas]> <![endif]><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>CREATE TABLE sales_region_coverage (coverage SDO_GEOMETRY);<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>DECLARE<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>coverage SDO_GEOMETRY := NULL;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>BEGIN<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>FOR g IN (SELECT geom FROM sales_regions) LOOP<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>coverage := SDO_GEOM.SDO_UNION(coverage, g.geom, 0.5);<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>END LOOP;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>INSERT INTO sales_region_coverage values (coverage);<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>COMMIT;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>END;<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>/<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><![if !supportEmptyParas]> <![endif]><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>304<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:SemiLight'>(SDO_GEOM.SDO_DIFFERENCE(csr.geom, sr.geom, 0.5)),</span><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SDO_GEOM.SDO_DIFFERENCE(csr.geom, sr.geom, 0.5),<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>307<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><b>Listing 9-20. </b></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><i>Area of the Intersection Region of Sales Region 1 and Sales Region 2</i></span><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><b>Listing 9-20. </b></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><i>Area of the Intersection Region of Sales Region 43 and Sales Region 51</i></span><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>316<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><b>Listing 9-28. </b></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><i>Finding the Coverage of </i></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'>sales_regions <i>Using </i></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'>SDO_AGGR_UNION</span><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><b>Listing 9-28. </b></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'><i>Finding the Coverage of </i></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'>Branch Locations <i>Using </i></span><span style='font-size:10.0pt;font-family:HelveticaNeue-BoldCond'>SDO_AGGR_UNION</span><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>343<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> EXEC show_net_details ('US_ROADS');<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SET SERVEROUTPUT ON<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> EXEC show_net_details ('US_ROADS');<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>483<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>(None—text was inserted at bottom of page)<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>The sample application uses the network data model Java API. The initial loading of the network needs a database connection: this connection uses a native OC4J data source. This data source must be defined in the configuration file $OC4J_HOME/j2ee/home/config/data-sources.xml<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>Add the following OC4J data source definition in the configuration file:<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'><data-source<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>class="com.evermind.sql.DriverManagerDataSource"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>name="spatial10g"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>location="jdbc/spatial10gCore"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>xa-location="jdbc/xa/spatial10gXA"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>ejb-location="jdbc/spatial10g"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>connection-driver="oracle.jdbc.driver.OracleDriver"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>username="spatial"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>password="spatial"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>url="jdbc:oracle:thin:@localhost:1521:orcl101"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>inactivity-timeout="30"<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>/><o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:Utopia-Regular'>Do not forget to adapt the database connection parameters to match your own setup. You can also define the MapViewer datasource based on this OC4J datasource. Read about this possibility on page 399 in Chapter 11.<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><![if !supportEmptyParas]> <![endif]><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'><o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>581<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>WHERE b.table_name = 'CUSTOMERS' and b.column_name='LOCATION'<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>(None-line was deleted)<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>587<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>(None-text was inserted directly above Listing 14-15)<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>INSERT INTO USER_SDO_GEOM_METADATA VALUES<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>('WEATHER_PATTERNS', 'GEOM',<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SDO_DIM_ARRAY(<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SDO_DIM_ELEMENT('LONG', -180, 180, 0.5),<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SDO_DIM_ELEMENT('LAT', -90, 90, 0.5)<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>),<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>8307<o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>);<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>642<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> UPDATE branches SET georaster = SDO_GEOR.INIT('BRANCHES_RDT'); WHERE id=1<o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>SQL> UPDATE branches SET georaster = SDO_GEOR.INIT('BRANCHES_RDT') WHERE id=1;<o:p></o:p></span></p> </td> </tr> <tr> <td width=50 style='width:.7in;border:solid gray 1.0pt;border-top:none; mso-border-top-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 3.5in 280.0pt 308.0pt 336.0pt; mso-layout-grid-align:none;text-autospace:none'><span style='font-family: Verdana'>649<o:p></o:p></span></p> </td> <td width=257 style='width:256.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'></theme><o:p></o:p></span></p> </td> <td width=293 style='width:292.5pt;border-top:none;border-left:none; border-bottom:solid gray 1.0pt;border-right:solid gray 1.0pt;mso-border-top-alt: solid gray 1.0pt;mso-border-left-alt:solid gray 1.0pt;padding:0in 5.4pt 0in 5.4pt'> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'></theme><o:p></o:p></span></p> <p class=MsoNormal style='mso-pagination:none;mso-layout-grid-align:none; text-autospace:none'><span style='font-size:10.0pt;font-family:TheSansMonoCondensed-SemiLight'>COMMIT;<o:p></o:p></span></p> </td> </tr></table><p class=MsoNormal><![if !supportEmptyParas]> <![endif]><o:p></o:p></p></div></body></html>