Том Кайт: о запросах первых n строк и запросах с разбивкой на страницы
.GroupHeaderid4siteid0{Background-Color:#336699;Height:20;Text-Align:Left;}
.GroupHeaderLinkid4siteid0{Color:#FFFFFF;Font-Family:Arial, Helvetica;Font-Size:9pt;Font-Weight:Bold;}
.GroupHeaderTextid4siteid0{Color:#FFFFFF;Font-Family:Arial, Helvetica;Font-Size:9pt;Font-Weight:Bold;}
.RegionHeaderid4siteid0{Background-Color:#666666;Height:20;Text-Align:left;}
.RegionHeaderTextid4siteid0{Color:#FFFFFF;Font-Family:Tahoma;Font-Size:8pt;Font-Weight:Bold;}
.Bodyid4siteid0{Background-Color:#FFFFFF;}
.Collateral_Typeid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.Elogger_Trackableid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_AUTHENTICATIONid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRYid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRY_REGIONid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_DISPLAYABLEid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_INITIATIVES_INVOLVEMENTid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_LANGUAGEid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_MASTERid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_OPN_ACCESS_LEVELid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_OPP_LEVELid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_PARTNER_TYPEid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_PRIORITYid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_REGIONid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_SEARCHABLEid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_SUMMARYid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_TECH_TRACKid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PRSubHeadingid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Approvalid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category1id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category2id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category3id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category4id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category5id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category6id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category7id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Company1id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Company2id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Contact_Name1id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Contact_Name2id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Email1id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Email2id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Headingid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Locationid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Phone1id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Phone2id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.Searchableid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.authorid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.createdateid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.creatorid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.defaultattributeid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.descriptionid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.documentsizeid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.expiredateid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.inplacedisplayid4siteid0{Color:#000000;Font-Family:Tahoma;Font-Size:12pt;Font-Weight:Bold;}
.itemfunctionid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.keywordsid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.perspectivesid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.scoreid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.subpagetitleid4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.titleid4siteid0{Color:#000000;Font-Family:Tahoma;Font-Size:8pt;}
.titleorimageid4siteid0{Color:#000000;Font-Family:Tahoma;Font-Size:8pt;}
.wwsbr_category_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_charset_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_itemtype_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_mime_type_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_page_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_pagegroup_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_publishdate_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_updatedate_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_updator_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_version_number_id4siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.LeftCurve{Background-Attachment:scroll;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFl.gif);Background-Position:left top;Background-Repeat:no-repeat;}
.PortletBodyColor{}
.PortletHeaderColor{Background-Color:#336699;}
.PortletHeaderLink{Color:#FFFFFF;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PortletHeaderStyle{}
.PortletHeaderText{Color:#FFFFFF;Font-Family:Arial, Helvetica;Font-Size:10pt;Font-Weight:Bold;}
.PortletHeading1{Color:#336699;Font-Family:Arial, Helvetica;Font-Size:9pt;Font-Weight:Bold;}
.PortletHeading2{Color:#336699;Font-Family:Arial, Helvetica;Font-Size:8pt;Font-Weight:Bold;}
.PortletHeading3{Color:#336699;Font-Family:Arial, Helvetica;Font-Size:7pt;Font-Weight:Bold;}
.PortletHeading4{Color:#336699;Font-Family:Arial, Helvetica;Font-Size:7pt;Font-Weight:Bold;}
.PortletSubHeaderColor{Background-Color:#EEEEDD;}
.PortletSubHeaderLink{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PortletSubHeaderText{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PortletText1{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PortletText2{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PortletText3{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:7pt;}
.PortletText4{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:7pt;}
.RightCurve{Background-Attachment:scroll;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFr.gif);Background-Position:right top;Background-Repeat:no-repeat;}
.LeftSubTabid4siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsl.gif);Background-Position:left top;Background-Repeat:no-repeat;}
.LeftTabBgSlantid4siteid0{Background-Attachment:scroll;Background-Color:#CCCC99;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Position:left top;Background-Repeat:no-repeat;}
.LeftTabForeSlantid4siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Position:left top;Background-Repeat:no-repeat;}
.RightSubTabid4siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsr.gif);Background-Position:right top;Background-Repeat:no-repeat;}
.RightTabBgCurveid4siteid0{Background-Attachment:scroll;Background-Color:#CCCC99;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Position:right top;Background-Repeat:no-repeat;}
.RightTabForeCurveid4siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Position:right top;Background-Repeat:no-repeat;}
.SubTabBgTextid4siteid0{Color:#CCCC99;Text-Decoration:none;Font-Family:Arial, Helvetica;Font-Size:11pt;Font-Weight:Bold;}
.TabBackgroundColorid4siteid0{Background-Color:#CCCC99;}
.TabBackgroundTextid4siteid0{Color:#003366;Text-Decoration:none;Font-Family:Arial, Helvetica;Font-Size:10pt;}
.TabForegroundColorid4siteid0{Background-Color:#336699;}
.TabForegroundTextid4siteid0{Color:#FFFFFF;Text-Decoration:none;Font-Family:Arial, Helvetica;Font-Size:10pt;Font-Weight:Bold;}
.portlet-font{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-font-dim{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-msg-status{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-msg-info{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-msg-error{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-msg-alert{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-msg-success{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-section-header{Color:#336699; Font-Family:Arial, Helvetica; Font-Size:9pt; Font-Weight:Bold; }
.portlet-section-body{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-section-alternate{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-section-selected{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-section-subheader{Color:#336699; Font-Family:Arial, Helvetica; Font-Size:8pt; Font-Weight:Bold; }
.portlet-section-footer{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-section-text{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-table-header{Color:#336699; Font-Family:Arial, Helvetica; Font-Size:9pt; Font-Weight:Bold; Background-Color:#EEEEDD; }
.portlet-table-body{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-table-alternate{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-table-selected{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-table-subheader{Color:#336699; Font-Family:Arial, Helvetica; Font-Size:8pt; Font-Weight:Bold; }
.portlet-table-footer{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-table-text{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-form-label{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-form-input-field{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-form-button{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-icon-label{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-dlg-icon-label{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-form-field-label{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.portlet-form-field{Color:#000000; Font-Family:Arial, Helvetica; Font-Size:8pt; }
.RegionNoBorder{}
.RegionBorder { border:#336699 1px solid; }
.RegionHeaderColor { background-color:; border:#336699 0px solid }
.PageColor { background-color:#FFFFFF}
.GroupHeaderid1siteid0{Text-Align:Left;Height:20;Background-Color:#336699;}
.GroupHeaderLinkid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.GroupHeaderTextid1siteid0{Font-Size:9pt;Font-Family:Arial, Helvetica;Font-Weight:Bold;Color:#FFFFFF;}
.RegionHeaderid1siteid0{Background-Color:#336699;Text-Align:Left;Height:20;}
.RegionHeaderTextid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.Bodyid1siteid0{Background-Color:#FFFFFF;}
.Collateral_Typeid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.Elogger_Trackableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_AUTHENTICATIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRYid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRY_REGIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_DISPLAYABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_INITIATIVES_INVOLVEMENTid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_LANGUAGEid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_MASTERid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_OPN_ACCESS_LEVELid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_OPP_LEVELid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PPG_PARTNER_TYPEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_PRIORITYid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_REGIONid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_SEARCHABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_SUMMARYid1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PPG_TECH_TRACKid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PRSubHeadingid1siteid0{Font-Size:10pt;Font-Weight:Bold;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Approvalid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category2id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.PR_Category3id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category4id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category5id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PR_Category6id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category7id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Company1id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:9pt;}
.PR_Company2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Contact_Name1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;Font-Weight:Bold;}
.PR_Contact_Name2id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Email1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Email2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Headingid1siteid0{Text-Decoration:none;Font-Weight:Bold;Font-Size:12pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Locationid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Phone1id1siteid0{Font-Family:Arial, Helvetica;Font-Size:9pt;Color:#000000;}
.PR_Phone2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.Searchableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.authorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.createdateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.creatorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.defaultattributeid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.descriptionid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.documentsizeid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.expiredateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.inplacedisplayid1siteid0{Font-Size:9pt;Color:#000000;Font-Family:Arial, Helvetica;}
.itemfunctionid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.keywordsid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.perspectivesid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.scoreid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.subpagetitleid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.titleid1siteid0{Color:#000000;Font-Weight:Bold;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.titleorimageid1siteid0{Color:#336699;Text-Decoration:Underline;Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;}
.wwsbr_category_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_charset_id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.wwsbr_itemtype_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_mime_type_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_page_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_pagegroup_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_publishdate_id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_updatedate_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.wwsbr_updator_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_version_number_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.LeftSubTabid1siteid0{Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsl.gif);Background-Color:#336699;Background-Attachment:scroll;}
.LeftTabBgSlantid1siteid0{Background-Color:#CCCC99;Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;}
.LeftTabForeSlantid1siteid0{Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;Background-Color:#336699;Background-Position:left top;}
.RightSubTabid1siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Position:right top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsr.gif);}
.RightTabBgCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Repeat:no-repeat;Background-Color:#CCCC99;Background-Attachment:scroll;Background-Position:right top;}
.RightTabForeCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Color:#336699;Background-Attachment:scroll;Background-Position:right top;Background-Repeat:no-repeat;}
.SubTabBgTextid1siteid0{Color:#CCCC99;Font-Size:11pt;Font-Weight:Bold;Text-Decoration:none;Font-Family:Arial, Helvetica;}
.TabBackgroundColorid1siteid0{Background-Color:#CCCC99;}
.TabBackgroundTextid1siteid0{Color:#003366;Text-Decoration:none;Font-Size:10pt;Font-Family:Arial, Helvetica;}
.TabForegroundColorid1siteid0{Background-Color:#336699;}
.TabForegroundTextid1siteid0{Color:#FFFFFF;Font-Weight:Bold;Font-Size:10pt;Font-Family:Arial, Helvetica;Text-Decoration:none;}
.GroupHeaderid1siteid0{Text-Align:Left;Height:20;Background-Color:#336699;}
.GroupHeaderLinkid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.GroupHeaderTextid1siteid0{Font-Size:9pt;Font-Family:Arial, Helvetica;Font-Weight:Bold;Color:#FFFFFF;}
.RegionHeaderid1siteid0{Background-Color:#336699;Text-Align:Left;Height:20;}
.RegionHeaderTextid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.Bodyid1siteid0{Background-Color:#FFFFFF;}
.Collateral_Typeid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.Elogger_Trackableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_AUTHENTICATIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRYid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRY_REGIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_DISPLAYABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_INITIATIVES_INVOLVEMENTid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_LANGUAGEid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_MASTERid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_OPN_ACCESS_LEVELid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_OPP_LEVELid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PPG_PARTNER_TYPEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_PRIORITYid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_REGIONid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_SEARCHABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_SUMMARYid1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PPG_TECH_TRACKid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PRSubHeadingid1siteid0{Font-Size:10pt;Font-Weight:Bold;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Approvalid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category2id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.PR_Category3id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category4id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category5id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PR_Category6id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category7id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Company1id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:9pt;}
.PR_Company2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Contact_Name1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;Font-Weight:Bold;}
.PR_Contact_Name2id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Email1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Email2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Headingid1siteid0{Text-Decoration:none;Font-Weight:Bold;Font-Size:12pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Locationid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Phone1id1siteid0{Font-Family:Arial, Helvetica;Font-Size:9pt;Color:#000000;}
.PR_Phone2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.Searchableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.authorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.createdateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.creatorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.defaultattributeid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.descriptionid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.documentsizeid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.expiredateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.inplacedisplayid1siteid0{Font-Size:9pt;Color:#000000;Font-Family:Arial, Helvetica;}
.itemfunctionid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.keywordsid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.perspectivesid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.scoreid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.subpagetitleid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.titleid1siteid0{Color:#000000;Font-Weight:Bold;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.titleorimageid1siteid0{Color:#336699;Text-Decoration:Underline;Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;}
.wwsbr_category_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_charset_id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.wwsbr_itemtype_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_mime_type_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_page_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_pagegroup_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_publishdate_id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_updatedate_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.wwsbr_updator_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_version_number_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.LeftSubTabid1siteid0{Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsl.gif);Background-Color:#336699;Background-Attachment:scroll;}
.LeftTabBgSlantid1siteid0{Background-Color:#CCCC99;Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;}
.LeftTabForeSlantid1siteid0{Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;Background-Color:#336699;Background-Position:left top;}
.RightSubTabid1siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Position:right top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsr.gif);}
.RightTabBgCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Repeat:no-repeat;Background-Color:#CCCC99;Background-Attachment:scroll;Background-Position:right top;}
.RightTabForeCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Color:#336699;Background-Attachment:scroll;Background-Position:right top;Background-Repeat:no-repeat;}
.SubTabBgTextid1siteid0{Color:#CCCC99;Font-Size:11pt;Font-Weight:Bold;Text-Decoration:none;Font-Family:Arial, Helvetica;}
.TabBackgroundColorid1siteid0{Background-Color:#CCCC99;}
.TabBackgroundTextid1siteid0{Color:#003366;Text-Decoration:none;Font-Size:10pt;Font-Family:Arial, Helvetica;}
.TabForegroundColorid1siteid0{Background-Color:#336699;}
.TabForegroundTextid1siteid0{Color:#FFFFFF;Font-Weight:Bold;Font-Size:10pt;Font-Family:Arial, Helvetica;Text-Decoration:none;}
.GroupHeaderid1siteid0{Text-Align:Left;Height:20;Background-Color:#336699;}
.GroupHeaderLinkid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.GroupHeaderTextid1siteid0{Font-Size:9pt;Font-Family:Arial, Helvetica;Font-Weight:Bold;Color:#FFFFFF;}
.RegionHeaderid1siteid0{Background-Color:#336699;Text-Align:Left;Height:20;}
.RegionHeaderTextid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.Bodyid1siteid0{Background-Color:#FFFFFF;}
.Collateral_Typeid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.Elogger_Trackableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_AUTHENTICATIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRYid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRY_REGIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_DISPLAYABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_INITIATIVES_INVOLVEMENTid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_LANGUAGEid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_MASTERid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_OPN_ACCESS_LEVELid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_OPP_LEVELid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PPG_PARTNER_TYPEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_PRIORITYid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_REGIONid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_SEARCHABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_SUMMARYid1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PPG_TECH_TRACKid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PRSubHeadingid1siteid0{Font-Size:10pt;Font-Weight:Bold;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Approvalid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category2id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.PR_Category3id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category4id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category5id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PR_Category6id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category7id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Company1id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:9pt;}
.PR_Company2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Contact_Name1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;Font-Weight:Bold;}
.PR_Contact_Name2id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Email1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Email2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Headingid1siteid0{Text-Decoration:none;Font-Weight:Bold;Font-Size:12pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Locationid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Phone1id1siteid0{Font-Family:Arial, Helvetica;Font-Size:9pt;Color:#000000;}
.PR_Phone2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.Searchableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.authorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.createdateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.creatorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.defaultattributeid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.descriptionid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.documentsizeid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.expiredateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.inplacedisplayid1siteid0{Font-Size:9pt;Color:#000000;Font-Family:Arial, Helvetica;}
.itemfunctionid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.keywordsid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.perspectivesid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.scoreid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.subpagetitleid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.titleid1siteid0{Color:#000000;Font-Weight:Bold;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.titleorimageid1siteid0{Color:#336699;Text-Decoration:Underline;Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;}
.wwsbr_category_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_charset_id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.wwsbr_itemtype_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_mime_type_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_page_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_pagegroup_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_publishdate_id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_updatedate_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.wwsbr_updator_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_version_number_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.LeftSubTabid1siteid0{Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsl.gif);Background-Color:#336699;Background-Attachment:scroll;}
.LeftTabBgSlantid1siteid0{Background-Color:#CCCC99;Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;}
.LeftTabForeSlantid1siteid0{Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;Background-Color:#336699;Background-Position:left top;}
.RightSubTabid1siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Position:right top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsr.gif);}
.RightTabBgCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Repeat:no-repeat;Background-Color:#CCCC99;Background-Attachment:scroll;Background-Position:right top;}
.RightTabForeCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Color:#336699;Background-Attachment:scroll;Background-Position:right top;Background-Repeat:no-repeat;}
.SubTabBgTextid1siteid0{Color:#CCCC99;Font-Size:11pt;Font-Weight:Bold;Text-Decoration:none;Font-Family:Arial, Helvetica;}
.TabBackgroundColorid1siteid0{Background-Color:#CCCC99;}
.TabBackgroundTextid1siteid0{Color:#003366;Text-Decoration:none;Font-Size:10pt;Font-Family:Arial, Helvetica;}
.TabForegroundColorid1siteid0{Background-Color:#336699;}
.TabForegroundTextid1siteid0{Color:#FFFFFF;Font-Weight:Bold;Font-Size:10pt;Font-Family:Arial, Helvetica;Text-Decoration:none;}
.GroupHeaderid1siteid0{Text-Align:Left;Height:20;Background-Color:#336699;}
.GroupHeaderLinkid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.GroupHeaderTextid1siteid0{Font-Size:9pt;Font-Family:Arial, Helvetica;Font-Weight:Bold;Color:#FFFFFF;}
.RegionHeaderid1siteid0{Background-Color:#336699;Text-Align:Left;Height:20;}
.RegionHeaderTextid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#FFFFFF;}
.Bodyid1siteid0{Background-Color:#FFFFFF;}
.Collateral_Typeid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.Elogger_Trackableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_AUTHENTICATIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRYid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_COUNTRY_REGIONid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_DISPLAYABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_INITIATIVES_INVOLVEMENTid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_LANGUAGEid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_MASTERid1siteid0{Color:#000000;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.PPG_OPN_ACCESS_LEVELid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_OPP_LEVELid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PPG_PARTNER_TYPEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_PRIORITYid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_REGIONid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PPG_SEARCHABLEid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PPG_SUMMARYid1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PPG_TECH_TRACKid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PRSubHeadingid1siteid0{Font-Size:10pt;Font-Weight:Bold;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Approvalid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category2id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.PR_Category3id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Category4id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category5id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.PR_Category6id1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.PR_Category7id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.PR_Company1id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:9pt;}
.PR_Company2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Contact_Name1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;Font-Weight:Bold;}
.PR_Contact_Name2id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Email1id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Email2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.PR_Headingid1siteid0{Text-Decoration:none;Font-Weight:Bold;Font-Size:12pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Locationid1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.PR_Phone1id1siteid0{Font-Family:Arial, Helvetica;Font-Size:9pt;Color:#000000;}
.PR_Phone2id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.Searchableid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.authorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.createdateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.creatorid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.defaultattributeid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.descriptionid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.documentsizeid1siteid0{Font-Size:8pt;Color:#000000;Font-Family:Arial, Helvetica;}
.expiredateid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.inplacedisplayid1siteid0{Font-Size:9pt;Color:#000000;Font-Family:Arial, Helvetica;}
.itemfunctionid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.keywordsid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.perspectivesid1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.scoreid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.subpagetitleid1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.titleid1siteid0{Color:#000000;Font-Weight:Bold;Font-Size:8pt;Font-Family:Arial, Helvetica;}
.titleorimageid1siteid0{Color:#336699;Text-Decoration:Underline;Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;}
.wwsbr_category_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_charset_id1siteid0{Font-Family:Arial, Helvetica;Color:#000000;Font-Size:8pt;}
.wwsbr_itemtype_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_mime_type_id1siteid0{Font-Family:Arial, Helvetica;Font-Size:8pt;Color:#000000;}
.wwsbr_page_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_pagegroup_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_publishdate_id1siteid0{Font-Weight:Bold;Font-Size:9pt;Font-Family:Arial, Helvetica;Color:#000000;}
.wwsbr_updatedate_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:9pt;}
.wwsbr_updator_id1siteid0{Color:#000000;Font-Family:Arial, Helvetica;Font-Size:8pt;}
.wwsbr_version_number_id1siteid0{Font-Size:8pt;Font-Family:Arial, Helvetica;Color:#000000;}
.LeftSubTabid1siteid0{Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsl.gif);Background-Color:#336699;Background-Attachment:scroll;}
.LeftTabBgSlantid1siteid0{Background-Color:#CCCC99;Background-Position:left top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;}
.LeftTabForeSlantid1siteid0{Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtl.gif);Background-Attachment:scroll;Background-Color:#336699;Background-Position:left top;}
.RightSubTabid1siteid0{Background-Attachment:scroll;Background-Color:#336699;Background-Position:right top;Background-Repeat:no-repeat;Background-Image:url(http://www.oracle.com/portalimages/FFFFFFsr.gif);}
.RightTabBgCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Repeat:no-repeat;Background-Color:#CCCC99;Background-Attachment:scroll;Background-Position:right top;}
.RightTabForeCurveid1siteid0{Background-Image:url(http://www.oracle.com/portalimages/FFFFFFtr.gif);Background-Color:#336699;Background-Attachment:scroll;Background-Position:right top;Background-Repeat:no-repeat;}
.SubTabBgTextid1siteid0{Color:#CCCC99;Font-Size:11pt;Font-Weight:Bold;Text-Decoration:none;Font-Family:Arial, Helvetica;}
.TabBackgroundColorid1siteid0{Background-Color:#CCCC99;}
.TabBackgroundTextid1siteid0{Color:#003366;Text-Decoration:none;Font-Size:10pt;Font-Family:Arial, Helvetica;}
.TabForegroundColorid1siteid0{Background-Color:#336699;}
.TabForegroundTextid1siteid0{Color:#FFFFFF;Font-Weight:Bold;Font-Size:10pt;Font-Family:Arial, Helvetica;Text-Decoration:none;}
Oracle Magazine - Русское издание (Май Июнь 2007)
Том Кайт
Том Кайт: о запросах первых n строк и запросах с разбивкой на страницы
(On Top-n and Pagination Queries, By Tom Kyte)
Источник: журнал Oracle Magazine, January-February 2007
(http://www.oracle.com/technology/oramag/oracle/07-jan/o17asktom.html).
Наш эксперт получает больше результатов, используя функции ROW_NUMBER, RANK и DENSE_RANK.
В недавнем выпуске колонки Ask Tom
(September/October 2006
– русский перевод: "Том Кайт: о столбце ROWNUM и ограничении размеров результирующих наборов" публикуется
в этом же выпуске журнала) я писал об использовании столбца ROWNUM для выполнения запросов первых n строк упорядоченного результирующего набора (top-n queries) и запросов с разбивкой на страницы (pagination queries), которые позволяют извлекать из результирующего набора строки в диапазоне от n от m.
В том выпуске колонки я показывал, как использовать столбец ROWNUM для извлечения первых 10 строк "вашего запроса":
select *
from
(ваш_запрос)
where rownum <= 10;
А также, как использовать столбец ROWNUM для извлечения строк "вашего запроса" в диапазоне от n до m:
select *
from
( select rownum rnum, a.*
from (ваш_запрос) a
where rownum <= :M )
where rnum >= :N;
Как всегда, в сервере Oracle Database есть несколько способов выполнения чего-либо, и эти запросы первых n строк и запросы с разбивкой на страницы – не исключение. В этом выпуске колонки я рассмотрю альтернативные способы использования этих функциональных возможностей с помощью аналитических функций, а также представлю еще одну разновидность запросов первых n строк: извлечение первых n строк с группированием по некоторому набору атрибутов, такому как извлечение набора строк таблицы EMP, представляющих троих самых высокооплачиваемых служащих каждого отдела (группирование по столбцу DEPTNO).
Запросы первых N строк
Другой способ написания запроса первых n строк – использование аналитической функции ROW_NUMBER (это похоже на ограничение числа строк, возвращаемых запросом, с помощью предложения LIMIT в СУБД MySQL или оператора "set rowcount" в СУБД SQL Server). Эта функция позволяет получить такие же результаты, которые позволяет получить псевдостолбец ROWNUM, но она более гибкая и имеет больше возможностей. В частности, я буду использовать ее в следующем разделе для извлечения первых n строк с группированием по некоторому набору атрибутов.
Давайте посмотрим, что функция ROW_NUMBER может делать. В следующем примере запрос использует эту функцию для присвоения возрастающих номеров строкам таблицы EMP после ее сортировки в убывающем порядке по столбцу SAL (оклад):
SQL> select ename, sal,
2 row_number()
3 over (order by sal desc) rn
4 from emp
5 order by sal desc
6 /
ENAME SAL RN
----- ---- --
KING 5000 1
FORD 3000 2
SCOTT 3000 3
JONES 2975 4
.
.
.
JAMES 950 13
SMITH 800 14
14 rows selected.
Итак, функция ROW_NUMBER позволяет мне легко присваивать эти возрастающие номера после сортировки таблицы, но, на первый взгляд, кажется, что она не поддерживает извлечение только первых n строк:
SQL> select ename, sal,
2 row_number()
3 over (order by sal desc) rn
4 from emp
5 where
6 row_number()
7 over (order by sal desc) <= 3
8 order by sal desc
9 /
row_number()
*
ERROR at line 6:
ORA-30483: window functions are not allowed here
Здесь проблема заключается в том, что аналитические функции вычисляются после обработки предложения WHERE, поэтому их нельзя использовать в предложении WHERE. На самом деле, это никакая не проблема, я же могу использовать вложенные представления – применить предикат после присвоения номеров. Например:
SQL> select *
2 from (
3 select ename, sal,
4 row_number()
5 over (order by sal desc) rn
6 from emp
7 )
8 where rn <= 3
9 order by sal desc
10 /
ENAME SAL RN
----- ---- --
KING 5000 1
SCOTT 3000 2
FORD 3000 3
3 rows selected.
Таким образом, это показывает, как с помощью функции ROW_NUMBER выполнять запросы первых n строк, а также указывает общую проблему запросов первых n строк. Посмотрите на результат, в нем две строки со значением 3000. Что если в таблице EMP оклад 3000 имеют не два человека, а три? Результат этого запроса – неоднозначный, поскольку я могу извлекать три записи, но они могут оказаться случайными. Например:
SQL> update emp
2 set sal = 3000
3 where ename = 'SMITH';
1 row updated.
SQL> select *
2 from (
3 select ename, sal,
4 row_number()
5 over (order by sal desc) rn
6 from emp
7 )
8 where rn <= 3
9 order by sal desc
10 /
ENAME SAL RN
----- ---- --
KING 5000 1
SMITH 3000 2
SCOTT 3000 3
3 rows selected.
Как видите, строка служащего FORD исчезла из результирующего набора. Если же вы сделаете это обновление и запросите ваши данные, эта строка может не исчезнуть, а исчезнет строка служащего SCOTT или SMITH – порядок исчезновения строк будет произвольным. Это – общая проблема запросов первых n строк: если в
-
dimplex model magic (sp8)
mastercard
hansa
salamander
metabo
rittal
8800 gold
5004.14 ()
xxx
kyiv apartments service
-
hi-fi
revol
-
russia music awards
orly
dimplex model elba
478
southpark
dolmar