锘??xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>&#20122;&#27954;&#65;&#86;&#26080;&#30721;&#65;&#86;&#21534;&#31934;&#20037;&#20037;&#44;&#57;&#55;&#20122;&#27954;&#29087;&#22919;&#33258;&#20599;&#33258;&#25293;&#21478;&#31867;&#22270;&#29255;&#44;&#20122;&#27954;&#22269;&#20135;&#25104;&#20154;&#20037;&#20037;&#19977;&#21306;</title><link>http://www.tkk7.com/fjpan2002/</link><description /><language>zh-cn</language><lastBuildDate>Tue, 13 May 2025 10:48:00 GMT</lastBuildDate><pubDate>Tue, 13 May 2025 10:48:00 GMT</pubDate><ttl>60</ttl><item><title>Oracle Sql鎻愮ず瀛︿範(fàn)絎旇</title><link>http://www.tkk7.com/fjpan2002/archive/2006/11/16/81565.html</link><dc:creator>鍕囨暍鐨勫績(jī)</dc:creator><author>鍕囨暍鐨勫績(jī)</author><pubDate>Thu, 16 Nov 2006 09:05:00 GMT</pubDate><guid>http://www.tkk7.com/fjpan2002/archive/2006/11/16/81565.html</guid><wfw:comment>http://www.tkk7.com/fjpan2002/comments/81565.html</wfw:comment><comments>http://www.tkk7.com/fjpan2002/archive/2006/11/16/81565.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.tkk7.com/fjpan2002/comments/commentRss/81565.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/fjpan2002/services/trackbacks/81565.html</trackback:ping><description><![CDATA[
		<div>1銆丗IRST_ROWS</div>
		<div>聽(tīng)聽(tīng) 鎸囩ず浼樺寲鍣ㄥ敖鍙兘蹇湴榪斿洖鍓峮琛岃褰曪紝鎻愰珮鍝嶅簲閫熷害銆傚鏋滄病鏈夋寚瀹氬弬鏁幫紝鍒欒繑鍥炵涓�琛屻�傝鎻愮ず瀵筓pdate鍜孖nsert鏃犳晥錛屽鍖呭惈鍧楁搷浣滅殑select璇彞鏃犳晥錛屽鎺掑簭鍜実roup銆?榪欐牱鐨勮鍙ヤ笉鑳戒紭鍖栨渶浣?jīng)_搷搴旀椂闂達(dá)紝鍥犱負(fù)Oracle鍦ㄨ繑鍥炵涓�琛屼箣鍓嶏紝蹇呴』鑾峰緱鎵�鏈夌殑璁板綍銆傚鏋滃湪榪欑鎯呭喌涓嬩嬌鐢ㄤ簡(jiǎn)璇ユ彁紺猴紝浼樺寲鍣ㄤ細(xì)浼樺寲鏈�浣?jīng)_悶鍚愰噺(鐩稿綋浜嶢LL_ROWS鎻愮ず)銆?/div>
		<div>聽(tīng)</div>
		<div>2銆丗ULL</div>
		<div>聽(tīng)聽(tīng) 鎸囩ず浼樺寲鍣ㄦ墽琛屽叏琛ㄦ壂鎻忥紝鍗充嬌鏈夌儲(chǔ)寮曪紝涔熶笉浼?xì)璧扮储寮曘�?/div>
		<div>聽(tīng)聽(tīng) </div>
		<div>
				<div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee">
						<img id="Codehighlighter1_10_23_Open_Image" onclick="this.style.display='none'; Codehighlighter1_10_23_Open_Text.style.display='none'; Codehighlighter1_10_23_Closed_Image.style.display='inline'; Codehighlighter1_10_23_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" />
						<img id="Codehighlighter1_10_23_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_10_23_Closed_Text.style.display='none'; Codehighlighter1_10_23_Open_Image.style.display='inline'; Codehighlighter1_10_23_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align="top" />
						<span style="COLOR: #000000">聽(tīng)聽(tīng)聽(tīng)</span>
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span id="Codehighlighter1_10_23_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">/**/</span>
						<span id="Codehighlighter1_10_23_Open_Text">
								<span style="COLOR: #008080">/*</span>
								<span style="COLOR: #008080">+聽(tīng)FULL(e)聽(tīng)</span>
								<span style="COLOR: #008080">*/</span>
						</span>
						<span style="COLOR: #000000">聽(tīng)employee_id,聽(tīng)last_name<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" />聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)</span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)hr.employees聽(tīng)e聽(tīng)</span>
						<span style="COLOR: #0000ff">WHERE</span>
						<span style="COLOR: #000000">聽(tīng)last_name聽(tīng)</span>
						<span style="COLOR: #808080">LIKE</span>
						<span style="COLOR: #000000">聽(tīng):b1;</span>
				</div>
		</div>
		<div>聽(tīng)聽(tīng) </div>
		<div>聽(tīng)聽(tīng) 娉ㄦ剰錛氬鏋滆〃鏈夊埆鍚嶏紝鍒欏繀欏諱嬌鐢ㄥ埆鍚嶃�傚茍涓斿嵆浣胯〃鍔犱笂浜?jiǎn)schema鍚嶇О錛屽湪鎻愮ず涓篃涓嶈兘鎸囧畾schema鍚嶇О銆?/div>
		<div>聽(tīng)</div>
		<div>3銆丠ASH</div>
		<div>聽(tīng)聽(tīng) 鎸囩ず浼樺寲鍣ㄤ嬌鐢℉ash鎵弿琛紝鍙�傜敤浜庤〃綈囦腑鐨勮〃銆?/div>
		<div>聽(tīng)</div>
		<div>4銆両NDEX</div>
		<div>聽(tīng)聽(tīng) 鎸囩ず浼樺寲鍣ㄩ�傜敤Index鎵弿琛紝閫傜敤浜庡嚱鏁般�佸煙銆丅鏍?wèi)銆佷綅鍥懼拰浣嶅浘鑱斿悎绱㈠紩銆?/div>
		<div>聽(tīng)聽(tīng) Index鎻愮ず閬靛驚浠ヤ笅瑙勮寖錛?/div>
		<div>聽(tīng)聽(tīng) a銆佸鏋淚ndex鎻愮ず鎸囧畾鍗曚釜鐨勭儲(chǔ)寮曪紝閭ｄ箞鏁版嵁搴撴墽琛岃绱㈠紩涓婄殑鎵弿錛屼紭鍖栧櫒涓嶄細(xì)鎵ц鍏ㄨ〃鎵弿鎴栬�呰〃涓婄殑鍏朵粬绱㈠紩銆?/div>
		<div>聽(tīng)聽(tīng) b銆佸浜庢寚瀹氫簡(jiǎn)澶氫釜绱㈠紩鐨勭粍鍚堢殑Index鎻愮ず錛孫racle鎺ㄨ崘浣跨敤INDEX_COMBINE鑰屼笉鏄疘NDEX鎻愮ず錛屽洜涓哄畠鏇村姞閫氱敤錛屽鏋淚ndex鎻愮ず鎸囧畾浜?jiǎn)index鍒楄〃錛岄偅涔堜紭鍖栧櫒浼?xì)鑰冭檻璧版瘡涓儲(chǔ)寮曠殑浠ｇ爜錛屽茍浠庝腑閫夋嫨浠ｄ環(huán)鏈�灝忕殑涓�鏉＄儲(chǔ)寮曪紝濡傛灉鎵弿澶氫釜index鐨勪唬浠鋒渶灝忥紝閭ｄ箞浼樺寲鍣ㄤ細(xì)鎵弿璇ヤ釜绱㈠紩鍒楄〃銆備紭鍖栧櫒涓嶄細(xì)璧板叏琛ㄦ壂鎻忔垨鑰呮病鏈夊湪index鍒楄〃涓婄殑绱㈠紩銆?/div>
		<div>聽(tīng)聽(tīng) c銆佸鏋淚ndex鎻愮ず娌℃湁鎸囧畾Index錛屼紭鍖栧櫒浼?xì)璇勪及鎵弿姣忎釜Index鐨勪唬浠鳳紝騫墮�夋嫨浠ｄ環(huán)鏈�灝忕殑Index錛屽鏋滅粍鍚圛ndex浠ｄ環(huán)鏈�灝忥紝閭ｄ箞浼樺寲鍣ㄤ細(xì)閫夋嫨鎵弿澶氫釜绱㈠紩錛屽茍鍚堝茍緇撴灉闆嗐�備紭鍖栧櫒涓嶄細(xì)璧板叏琛ㄦ壂鎻忋�?/div>
		<div>聽(tīng)</div>
		<div>
				<div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee">
						<img id="Codehighlighter1_10_50_Open_Image" onclick="this.style.display='none'; Codehighlighter1_10_50_Open_Text.style.display='none'; Codehighlighter1_10_50_Closed_Image.style.display='inline'; Codehighlighter1_10_50_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" />
						<img id="Codehighlighter1_10_50_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_10_50_Closed_Text.style.display='none'; Codehighlighter1_10_50_Open_Image.style.display='inline'; Codehighlighter1_10_50_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align="top" />
						<span style="COLOR: #000000">聽(tīng)聽(tīng)聽(tīng)</span>
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span id="Codehighlighter1_10_50_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">/**/</span>
						<span id="Codehighlighter1_10_50_Open_Text">
								<span style="COLOR: #008080">/*</span>
								<span style="COLOR: #008080">+聽(tīng)I(yíng)NDEX聽(tīng)(employees聽(tīng)emp_department_ix)</span>
								<span style="COLOR: #008080">*/</span>
						</span>
						<span style="COLOR: #000000">聽(tīng)聽(tīng)employee_id,聽(tīng)department_id<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" />聽(tīng)聽(tīng)聽(tīng)聽(tīng)</span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)employees聽(tīng)</span>
						<span style="COLOR: #0000ff">WHERE</span>
						<span style="COLOR: #000000">聽(tīng)department_id聽(tīng)</span>
						<span style="COLOR: #808080">&gt;</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="FONT-WEIGHT: bold; COLOR: #800000">50</span>
						<span style="COLOR: #000000">;</span>
				</div>
		</div>
		<div>聽(tīng)</div>
		<div>5銆両NDEX_ASC</div>
		<div>聽(tīng)聽(tīng) 鎸夌儲(chǔ)寮曞�肩殑鍗囧簭鏂瑰悜鎵弿绱㈠紩錛屽叾浠栧弬鏁頒笌INDEX 鎻愮ず瀹屽叏涓�鏍楓�?/div>
		<div>聽(tīng)</div>
		<div>6銆両NDEX_COMBINE</div>
		<div>聽(tīng)聽(tīng) 鑱斿悎绱㈠紩鎻愮ず銆傜儲(chǔ)寮曡鍒欎笌INDEX鎻愮ず涓�鏍楓�?/div>
		<div>聽(tīng)聽(tīng) </div>
		<div>
				<div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee">
						<img id="Codehighlighter1_10_65_Open_Image" onclick="this.style.display='none'; Codehighlighter1_10_65_Open_Text.style.display='none'; Codehighlighter1_10_65_Closed_Image.style.display='inline'; Codehighlighter1_10_65_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" />
						<img id="Codehighlighter1_10_65_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_10_65_Closed_Text.style.display='none'; Codehighlighter1_10_65_Open_Image.style.display='inline'; Codehighlighter1_10_65_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align="top" />
						<span style="COLOR: #000000">聽(tīng)聽(tīng)聽(tīng)</span>
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span id="Codehighlighter1_10_65_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">/**/</span>
						<span id="Codehighlighter1_10_65_Open_Text">
								<span style="COLOR: #008080">/*</span>
								<span style="COLOR: #008080">+聽(tīng)I(yíng)NDEX_COMBINE(e聽(tīng)emp_manager_ix聽(tīng)emp_department_ix)聽(tīng)</span>
								<span style="COLOR: #008080">*/</span>
						</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="COLOR: #808080">*</span>
						<span style="COLOR: #000000">
								<br />
								<img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" />
						</span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)employees聽(tīng)e<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" /></span>
						<span style="COLOR: #0000ff">WHERE</span>
						<span style="COLOR: #000000">聽(tīng)manager_id聽(tīng)</span>
						<span style="COLOR: #808080">=</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="FONT-WEIGHT: bold; COLOR: #800000">108</span>
						<span style="COLOR: #000000">
								<br />
								<img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" />
						</span>
						<span style="COLOR: #808080">OR</span>
						<span style="COLOR: #000000">聽(tīng)department_id聽(tīng)</span>
						<span style="COLOR: #808080">=</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="FONT-WEIGHT: bold; COLOR: #800000">110</span>
						<span style="COLOR: #000000">;</span>
				</div>
		</div>
		<div>聽(tīng)</div>
		<div>7銆両NDEX_DESC</div>
		<div>聽(tīng) 闄嶅簭INDEX鎻愮ず銆?/div>
		<div>聽(tīng)</div>
		<div>
				<div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee">
						<img id="Codehighlighter1_7_38_Open_Image" onclick="this.style.display='none'; Codehighlighter1_7_38_Open_Text.style.display='none'; Codehighlighter1_7_38_Closed_Image.style.display='inline'; Codehighlighter1_7_38_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" />
						<img id="Codehighlighter1_7_38_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_7_38_Closed_Text.style.display='none'; Codehighlighter1_7_38_Open_Image.style.display='inline'; Codehighlighter1_7_38_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align="top" />
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span id="Codehighlighter1_7_38_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">/**/</span>
						<span id="Codehighlighter1_7_38_Open_Text">
								<span style="COLOR: #008080">/*</span>
								<span style="COLOR: #008080">+聽(tīng)I(yíng)NDEX_DESC(e聽(tīng)emp_name_ix)聽(tīng)</span>
								<span style="COLOR: #008080">*/</span>
						</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="COLOR: #808080">*</span>
						<span style="COLOR: #000000">
								<br />
								<img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" />
						</span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)employees聽(tīng)e;</span>
				</div>
		</div>
		<div>聽(tīng)</div>
		<div>8銆両NDEX_FFS</div>
		<div>聽(tīng) 鎸囩ず浼樺寲鍣ㄦ墽琛屽揩閫熷叏绱㈠紩鎵弿錛岃�屼笉鏄叏琛ㄦ壂鎻忋�?/div>
		<div>聽(tīng)</div>
		<div>
				<div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee">
						<img id="Codehighlighter1_7_37_Open_Image" onclick="this.style.display='none'; Codehighlighter1_7_37_Open_Text.style.display='none'; Codehighlighter1_7_37_Closed_Image.style.display='inline'; Codehighlighter1_7_37_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" />
						<img id="Codehighlighter1_7_37_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_7_37_Closed_Text.style.display='none'; Codehighlighter1_7_37_Open_Image.style.display='inline'; Codehighlighter1_7_37_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align="top" />
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span id="Codehighlighter1_7_37_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">/**/</span>
						<span id="Codehighlighter1_7_37_Open_Text">
								<span style="COLOR: #008080">/*</span>
								<span style="COLOR: #008080">+聽(tīng)I(yíng)NDEX_FFS(e聽(tīng)emp_name_ix)聽(tīng)</span>
								<span style="COLOR: #008080">*/</span>
						</span>
						<span style="COLOR: #000000">聽(tīng)first_name<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" /></span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)employees聽(tīng)e;</span>
				</div>
		</div>
		<div>聽(tīng)</div>
		<div>9銆両NDEX_JOIN</div>
		<div>聽(tīng)聽(tīng)浠NDEX JOIN鐨勬柟寮忔壂鎻忥紝蹇呴』瀛樺湪瓚沖灝戠殑INDEX錛岃繖浜涚儲(chǔ)寮曞寘鍚潃鏌ヨ涓墍鏈夌殑鍒椼�?/div>
		<div>聽(tīng)</div>
		<div>
				<div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee">
						<img id="Codehighlighter1_7_59_Open_Image" onclick="this.style.display='none'; Codehighlighter1_7_59_Open_Text.style.display='none'; Codehighlighter1_7_59_Closed_Image.style.display='inline'; Codehighlighter1_7_59_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" />
						<img id="Codehighlighter1_7_59_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_7_59_Closed_Text.style.display='none'; Codehighlighter1_7_59_Open_Image.style.display='inline'; Codehighlighter1_7_59_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align="top" />
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span id="Codehighlighter1_7_59_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">/**/</span>
						<span id="Codehighlighter1_7_59_Open_Text">
								<span style="COLOR: #008080">/*</span>
								<span style="COLOR: #008080">+聽(tīng)I(yíng)NDEX_JOIN(e聽(tīng)emp_manager_ix聽(tīng)emp_department_ix)聽(tīng)</span>
								<span style="COLOR: #008080">*/</span>
						</span>
						<span style="COLOR: #000000">聽(tīng)department_id<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" /></span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)employees聽(tīng)e聽(tīng)</span>
						<span style="COLOR: #0000ff">WHERE</span>
						<span style="COLOR: #000000">聽(tīng)manager_id聽(tīng)</span>
						<span style="COLOR: #808080">&lt;</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="FONT-WEIGHT: bold; COLOR: #800000">110</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="COLOR: #808080">AND</span>
						<span style="COLOR: #000000">聽(tīng)department_id聽(tīng)</span>
						<span style="COLOR: #808080">&lt;</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="FONT-WEIGHT: bold; COLOR: #800000">50</span>
						<span style="COLOR: #000000">;</span>
				</div>
		</div>
		<div>聽(tīng)</div>
		<div>10銆両NDEX_SS</div>
		<div>聽(tīng) 绱㈠紩璺寵穬鎵弿鎻愮ず銆?/div>
		<div>聽(tīng)</div>
		<div>11銆丩EADING</div>
		<div>聽(tīng) 鎸囧畾鐗瑰畾鐨勮〃鏀懼湪鎵ц璁″垝鐨勫墠闈紝瀹冩瘮ORDERED鎻愮ず鏇村姞閫氱敤銆?/div>
		<div>聽(tīng) 濡傛灉鍥犱負(fù)Join璺嚎鐨勪緷璧栧叧緋昏�屼笉鑳介鍏堣Join錛屾彁紺哄氨浼?xì)琚拷鐣ュQ涘鏋滄寚瀹氫簡(jiǎn)涓や釜鎴栬�呭涓啿紿佺殑LEADING鎻愮ず錛屽垯浠栦滑閮戒細(xì)琚拷鐣ワ紱濡傛灉鎸囧畾浜?jiǎn)ORDERED鎻愮ず錛岄偅涔圠EADING灝變細(xì)琚拷鐣ャ�?/div>
		<div>聽(tīng)</div>
		<div>12銆丮ERGE</div>
		<div>聽(tīng)聽(tīng)灝嗚鍥懼悎騫跺埌鏌ヨ銆?/div>
		<div>聽(tīng) 濡傛灉瑙嗗浘鏌ヨ璇彞鍖呭惈GROUP BY瀛愬彞鎴栬�匰ELECT璇彞涓敤鍒頒簡(jiǎn) DISTINCT錛岄偅涔堜紭鍖栧櫒鑳藉灝嗚鍥懼悎騫跺埌鏌ヨ璇彞涓紝鍚堟垚鐨勫悎騫朵篃鑳藉鍚堝茍IN瀛愭煡璇紝濡傛灉IN瀛愭煡璇㈡病鏈夊叧鑱斻�?/div>
		<div>聽(tīng)</div>
		<div>
				<div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee">
						<img id="Codehighlighter1_9_23_Open_Image" onclick="this.style.display='none'; Codehighlighter1_9_23_Open_Text.style.display='none'; Codehighlighter1_9_23_Closed_Image.style.display='inline'; Codehighlighter1_9_23_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" />
						<img id="Codehighlighter1_9_23_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_9_23_Closed_Text.style.display='none'; Codehighlighter1_9_23_Open_Image.style.display='inline'; Codehighlighter1_9_23_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align="top" />
						<span style="COLOR: #000000">聽(tīng)聽(tīng)</span>
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span id="Codehighlighter1_9_23_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">/**/</span>
						<span id="Codehighlighter1_9_23_Open_Text">
								<span style="COLOR: #008080">/*</span>
								<span style="COLOR: #008080">+聽(tīng)MERGE(v)聽(tīng)</span>
								<span style="COLOR: #008080">*/</span>
						</span>
						<span style="COLOR: #000000">聽(tīng)e1.last_name,聽(tīng)e1.salary,聽(tīng)v.avg_salary<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" /></span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)employees聽(tīng)e1,<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" />(</span>
						<span style="COLOR: #0000ff">SELECT</span>
						<span style="COLOR: #000000">聽(tīng)department_id,聽(tīng)</span>
						<span style="COLOR: #ff00ff">avg</span>
						<span style="COLOR: #000000">(salary)聽(tīng)avg_salary<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" /></span>
						<span style="COLOR: #0000ff">FROM</span>
						<span style="COLOR: #000000">聽(tīng)employees聽(tīng)e2<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" /></span>
						<span style="COLOR: #0000ff">GROUP</span>
						<span style="COLOR: #000000">聽(tīng)</span>
						<span style="COLOR: #0000ff">BY</span>
						<span style="COLOR: #000000">聽(tīng)department_id)聽(tīng)v<br /><img src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align="top" /></span>
						<span style="COLOR: #0000ff">WHERE</span>
						<span style="COLOR: #000000">聽(tīng)e1.department_id聽(tīng)</span>
						<span style="COLOR: #808080">=</span>
						<span style="COLOR: #000000">聽(tīng)v.department_id聽(tīng)</span>
						<span style="COLOR: #808080">AND</span>
						<span style="COLOR: #000000">聽(tīng)e1.salary聽(tīng)</span>
						<span style="COLOR: #808080">&gt;</span>
						<span style="COLOR: #000000">聽(tīng)v.avg_salary;</span>
				</div>
		</div>
		<div>聽(tīng)</div>
		<div>13銆丯OAPPEND</div>
		<div>聽(tīng)聽(tīng) 鍦ㄥ茍琛屾ā寮忎腑浣跨敤甯歌鎻掑叆鏂規(guī)硶銆?/div>
		<div>聽(tīng)</div>
		<div>14銆丯OCACHE</div>
		<div>聽(tīng)</div>
		<div>15銆丯O_EXPAND</div>
		<div>聽(tīng)</div>
		<div>16銆丯O_FACT</div>
		<div>聽(tīng)</div>
		<div>17銆丯O_INDEX</div>
		<div>聽(tīng)</div>
		<div>18銆丯O_INDEX_SS</div>
		<div>聽(tīng)</div>
		<div>19銆丯O_MERGE</div>
		<div>聽(tīng)</div>
		<div>20銆丯O_PARALLEL</div>
		<div>聽(tīng)聽(tīng) 瑕嗙洊浜?jiǎn)鋴社敤DDL璇█鍒涘緩鎴栬�呮洿鏀箃able鐨凱ARALLEL鍙傛暟鐨勮緗�?/div>
		<div>聽(tīng)</div>
		<div>21銆丯O_PARALLEL_INDEX</div>
		<div>聽(tīng)聽(tīng) 瑕嗙洊浜?jiǎn)鋴社敤DDL璇█鍒涘緩鎴栬�呮洿鏀筰ndex鐨凱ARALLEL鍙傛暟鐨勮緗�?/div>
		<div>聽(tīng)</div>
		<div>22銆丯O_PUSH_PRED</div>
		<div>聽(tīng)聽(tīng) </div>
		<div>23銆丯O_PUSH_SUBQ</div>
		<div>聽(tīng)</div>
		<div>24銆丯O_PX_JOIN_FILTER</div>
		<div>聽(tīng)聽(tīng)聽(tīng) 闃繪浼樺寲鍣ㄤ嬌鐢ㄥ茍琛岃仈鍚堜綅鍥捐繃婊ゅ櫒</div>
		<div>聽(tīng)</div>
		<div>25銆丯O_REWRITE</div>
		<div>聽(tīng)聽(tīng)聽(tīng) 浣挎煡璇㈤噸鍐欏け鏁?/div>
		<div>聽(tīng)</div>
		<div>26銆丯O_QUERY_TRANSFORMATION</div>
		<div>聽(tīng)聽(tīng)聽(tīng) 璺寵繃鎵�鏈夋煡璇㈣漿鎹紝鍖呮嫭浣嗕笉闄愪簬錛歄R-expansion銆佽鍥懼悎騫躲�佹棤宓屽瀛愭煡璇€�佹槦鍨嬭漿鎹㈠拰鐗╁寲瑙嗗浘閲嶅啓銆?/div>
		<div>聽(tīng)</div>
		<div>27銆丯O_STAR_TRANSFORMATION</div>
		<div>聽(tīng)</div>
		<div>28銆丯O_UNNEST</div>
		<div>聽(tīng)</div>
		<div>29銆丯O_USE_HASH</div>
		<div>聽(tīng)</div>
		<div>30銆丱RDERED</div>
		<div>聽(tīng)聽(tīng) 鎸囩ず浼樺寲鍣ㄦ寜鐓ROM瀛愬彞鍑虹幇鐨勮〃欏哄簭join琛ㄣ�侽racle鎺ㄨ崘浣跨敤LEADING鎻愮ず銆?/div>
		<div>聽(tīng)</div>
		<div>31銆丳ARALLEL</div>
		<div>聽(tīng)聽(tīng) 鎸囩ず浼樺寲鍣ㄤ嬌鐢ㄦ寚瀹氭暟鐩殑鏈嶅姟鍣ㄥ幓鎵ц騫惰鎿嶄綔錛屽寘鎷琒ELECT銆両NSERT銆丮ERGE銆乁PDATE鍜孌ELETE閮ㄥ垎鐨勮鍙ュ拰琛ㄦ壂鎻忛儴鍒嗛兘鍙嬌鐢ㄣ�?/div>
		<div>聽(tīng)聽(tīng) 娉ㄦ剰錛氬鏋滃彂鐢焥ort鎴栬�単roup錛岄偅涔堟湇鍔″櫒鐨勬暟閲忓簲璇ユ槸鎻愮ず鎸囧畾鐨勪袱鍊嶃�?/div>
		<div>聽(tīng)聽(tīng) 濡傛灉浠諱綍騫惰閮借紱佹錛岄偅涔堟彁紺哄氨浼?xì)琚拷鐣ャ�?/div>
		<div>聽(tīng)聽(tīng) 濡傛灉鎸囧畾浜?jiǎn)DEFAULT鎴栬�呮病鏈夋寚瀹氫換浣曞�鹼紝閭ｄ箞鏌ヨ鍣ㄥ氨浼?xì)鍘粙個(gè)鏌ュ垵濮嬪弬鏁扮殑璁劇疆鏉ュ喅瀹氬茍琛屽害銆?/div>
		<div>聽(tīng)聽(tīng) 涓存椂琛ㄤ笂鐨勮鎻愮ず灝嗕細(xì)琚拷鐣ャ�?/div>
		<div>聽(tīng)</div>
		<div>32銆丳ARALLEL_INDEX</div>
		<div>聽(tīng)聽(tīng) 涓哄垎鍖虹儲(chǔ)寮曟寚瀹氬茍琛岀儲(chǔ)寮曟壂鎻忕殑鏁伴噺銆傜ず渚嬶細(xì)</div>
		<div>聽(tīng)聽(tīng)聽(tīng) SELECT /*+ PARALLEL_INDEX(table1, index1, 3) */</div>
		<div>聽(tīng)</div>
		<div>33銆丳Q_DISTRIBUTE</div>
		<div>聽(tīng)</div>
		<div>34銆丳USH_PRED</div>
		<div>聽(tīng)</div>
		<div>35銆丳USH_SUBQ</div>
		<div>聽(tīng)</div>
		<div>36銆丷EWRITE</div>
		<div>聽(tīng)聽(tīng)聽(tīng) 瀵圭墿鍖栬鍥句嬌鐢ㄦ煡璇㈤噸鍐欍�?/div>
<img src ="http://www.tkk7.com/fjpan2002/aggbug/81565.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/fjpan2002/" target="_blank">鍕囨暍鐨勫績(jī)</a> 2006-11-16 17:05 <a href="http://www.tkk7.com/fjpan2002/archive/2006/11/16/81565.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Oracle Direct-Path Insert瀛︿範(fàn)絎旇</title><link>http://www.tkk7.com/fjpan2002/archive/2006/11/14/81051.html</link><dc:creator>鍕囨暍鐨勫績(jī)</dc:creator><author>鍕囨暍鐨勫績(jī)</author><pubDate>Tue, 14 Nov 2006 01:22:00 GMT</pubDate><guid>http://www.tkk7.com/fjpan2002/archive/2006/11/14/81051.html</guid><wfw:comment>http://www.tkk7.com/fjpan2002/comments/81051.html</wfw:comment><comments>http://www.tkk7.com/fjpan2002/archive/2006/11/14/81051.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/fjpan2002/comments/commentRss/81051.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/fjpan2002/services/trackbacks/81051.html</trackback:ping><description><![CDATA[
		<div>(1)銆丱racle鎻掑叆鏁版嵁鏈変袱縐嶆柟寮忥細(xì)</div>
		<div>a銆佸父瑙勬彃鍏ワ細(xì)閲嶆柊浣跨敤table涓殑鑷敱絀洪棿錛屽湪宸叉湁鏁版嵁涓彃鍏ユ柊鏁版嵁錛涚淮鎶ゅ紩鐢ㄥ畬鏁存�х害鏉熴�?/div>
		<div>b銆丏irect-Path鎻掑叆錛氬湪琛ㄤ腑宸叉湁鏁版嵁涔嬪悗鎻掑叆鏂版暟鎹紱鏁版嵁鐩存帴鎻掑叆鏁版嵁鏂囦歡錛岀粫榪嘼uffer cache錛涘凡鏈夋暟鎹腑鐨勮嚜鐢辯┖闂存病鏈夎閲嶆柊鍒╃敤錛涘拷鐣ヤ簡(jiǎn)寮曠敤瀹屾暣鎬х害鏉熴�?/div>
		<div>聽(tīng)</div>
		<div>錛?錛夈�佽繛緇ā寮忥細(xì)涓�涓繘紼嬫墽琛宻ql璇彞錛?/div>
		<div>聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng) 騫惰妯″紡錛氬涓繘紼嬪悓鏃舵墽琛屼竴涓猻ql璇彞錛屽嵆騫惰鎵ц銆?/div>
		<div>聽(tīng)</div>
		<div>錛?錛塂irect-Path鎻掑叆鐨勪紭鐐癸細(xì)</div>
		<div>1銆佸彲浠isable redo log鍜寀ndo log錛涜�屽父瑙勬彃鍏ュ嵈涓嶅彲浠ュ姝わ紝騫朵笖閲嶇敤鑷敱絀洪棿鍜岀淮鎶ゅ紩鐢ㄥ畬鏁存�с�?/div>
		<div>2銆侀�氳繃CREATE TABLE...AS SELECT 璇彞鍙互浠庣幇鏈夎〃涓垱寤烘柊琛紝浣跨敤Direct-Path鎻掑叆鍙互鍦ㄦ彃鍏ユ椂鏇存柊瀹氫箟鍦ㄧ洰鏍囪〃涓婄殑浠繪剰绱㈠紩銆?/div>
		<div>3銆丏irect-Path鎻掑叆鑳戒繚璇佷簨鍔＄殑鍘熷瓙鎬э紝鍗充嬌鍦ㄥ茍琛屾ā寮忎笅銆備嬌鐢⊿QL*Loader鍦ㄥ茍琛屾ā寮忓姞杞戒腑涓嶈兘淇濊瘉鍘熷瓙鎬с�?/div>
		<div>4銆佸綋騫惰Direct-Path鍔犺澆鍙戠敓閿欒鏃訛紝绱㈠紩琚爣蹇楁垚UNUSABLE銆?/div>
		<div>5銆佸鏋滄兂浣跨敤琛ㄥ帇緙╃殑鍘嬬緝鏍煎紡瀛樺偍鏁版嵁錛屽繀欏諱嬌鐢―irect-Path鎻掑叆銆?/div>
		<div>聽(tīng)</div>
		<div>聽(tīng)</div>
		<div>錛?錛変嬌鐢―irect-Path鎻掑叆錛?/div>
		<div>聽(tīng)</div>
		<div>鍦ㄨ繛緇ā寮忎腑錛屽湪Insert璇彞涓寚瀹氣�淎PPEND鈥濇彁紺猴紝鍦↖NSERT鍏抽敭瀛椾箣鍚庯紝鎴栬�呭湪INSERT瀛愭煡璇腑鐨凷ELECT鍏抽敭瀛椾箣鍚庛�?/div>
		<div>鍦ㄥ茍琛孌ML妯″紡涓紝榛樿鐨勫氨鏄疍IRECT-PATH鎻掑叆錛屼負(fù)浜?jiǎn)杩愯迤堣DML妯″紡錛屽繀欏繪弧瓚充互涓嬫潯浠訛細(xì)</div>
		<div>a銆佸繀欏繪槸Oracle浼佷笟鐗堬紱</div>
		<div>b銆佸繀欏誨湪session涓嬌騫惰DML鐢熸晥錛屾墽琛屼互涓媠ql璇彞錛?/div>
		<div>ALTER SESSION { ENABLE | FORCE } PARALLEL DML;</div>
		<div>c銆佸繀欏繪寚瀹歵able鐨勫茍琛屽睘鎬э紝鍦ㄥ垱寤虹殑鏃跺�欐垨鑰呭叾浠栨椂鍊欙紝鎴栬�呭湪insert鎿嶄綔鏃朵嬌鐢ㄢ�淧ARALLEL鈥濇彁紺恒�?/div>
		<div>聽(tīng)</div>
		<div>涓轟簡(jiǎn)浣緿irect-Path Insert妯″紡澶辨晥錛屽湪INSERT璇彞涓寚瀹氣�淣OAPPEND鈥濇彁紺猴紝瑕嗙洊騫惰DML妯″紡銆?/div>
		<div>聽(tīng)</div>
		<div>錛?錛夈�丏irect-Path INSERT 鏄浣曞伐浣滅殑</div>
		<div>聽(tīng)</div>
		<div>鍦ㄥ垎鍖鴻〃鍜岄潪鍒嗗尯琛ㄩ兘鍙互浣跨敤Direct-Path INSERT</div>
		<div>聽(tīng)</div>
		<div>榪炵畫Direct-Path INSERT鍒板垎鍖哄拰闈炲垎鍖鴻〃</div>
		<div>聽(tīng) 鍗曚釜榪涚▼鎻掑叆鏁版嵁鍒伴珮姘翠綅鏍囧織涔嬩笂錛屽綋鎵ц瀹宑ommit涔嬪悗錛岄珮姘翠綅鏍囧織寰楀埌鏇存柊銆?/div>
		<div>聽(tīng)</div>
		<div>騫惰Direct-Path INSERT鍒板垎鍖鴻〃</div>
		<div>聽(tīng) 綾諱技浜巗erial Direct-Path INSERT錛屾瘡涓茍琛屾搷浣滃垎閰嶇粰涓�涓垨鑰呭涓垎鍖猴紝姣忎釜騫惰鎿嶄綔鎻掑叆鏁版嵁鍒板悇鑷殑鍒嗗尯孌電殑楂樻按浣嶆爣蹇椾箣涓婏紝commit涔嬪悗錛岀敤鎴峰氨鑳界湅鍒版洿鏂扮殑鏁版嵁銆?/div>
		<div>聽(tīng)</div>
		<div>騫惰Direct-Path INSERT鍒伴潪鍒嗗尯琛?/div>
		<div>聽(tīng) 姣忎釜騫惰鎵ц鍒嗛厤涓�涓柊鐨勪復(fù)鏃舵錛屽茍鎻掑叆鏁版嵁鍒頒復(fù)鏃舵銆傚綋commit榪愯鍚庯紝騫惰鎵ц鍗忚皟鑰呭悎騫舵柊鐨勪復(fù)鏃舵鍒頒富琛ㄦ錛岀敤鎴峰氨鑳界湅鍒版洿鏂扮殑鏁版嵁銆?/div>
		<div>聽(tīng)</div>
		<div>涓篋irect-Path INSERT鎸囧畾鐨凩og妯″紡</div>
		<div>聽(tīng)聽(tīng) Direct-Path INSERT鍙互浣跨敤Log鎴栬�呬笉浣跨敤Log銆?/div>
		<div>聽(tīng)</div>
		<div>錛?錛夈�佸叾浠栭渶瑕佹敞鎰忕殑鍦版柟錛?/div>
		<div>聽(tīng)聽(tīng)聽(tīng) 绱㈠紩緇存姢錛歄racle鍦―irect-Path INSERT 鎿嶄綔鏈熬錛屽鍏鋒湁绱㈠紩鐨勮〃鎵ц绱㈠紩緇存姢錛岃繖鏍峰氨閬垮厤浜?jiǎn)鍦╠rop鎺夌儲(chǔ)寮曞悗錛屽啀rebuild銆?/div>
		<div>聽(tīng)聽(tīng)聽(tīng) 浣跨敤鐨勭┖闂達(dá)細(xì)Direct-Path INSERT姣斿父瑙勭殑鎻掑叆闇�瑕佹洿澶氱殑絀洪棿銆傚洜涓哄畠?yōu)畣鏁版嵁鎻掑叆鍦ㄩ珮姘翠綅涔嬩笂銆傚茍琛屾彃鍏ラ潪鍒嗗尯琛ㄩ渶瑕佹洿澶氱殑絀洪棿錛屽洜涓哄畠闇�瑕佷負(fù)姣忎竴涓茍琛屽垱寤轟復(fù)鏃舵銆?/div>
		<div>聽(tīng)聽(tīng)聽(tīng) 閿侊細(xì)鍦ㄦ彃鍏ユ湡闂達(dá)紝鏁版嵁搴撳湪琛ㄤ笂鑾峰緱鎺掍粬閿侊紝鐢ㄦ埛涓嶈兘鍦ㄨ〃涓婃墽琛屽茍琛屾彃鍏ャ�佹洿鏂版垨鑰呭垹闄ゆ搷浣滐紝騫惰鐨勭儲(chǔ)寮曞垱寤哄拰build涔熶笉琚厑璁搞�備絾鍗村彲浠ュ茍琛屾煡璇紝浣嗘煡璇㈣繑鍥炵殑鏄彃鍏ヤ箣鍓嶇殑緇撴灉闆嗐�?/div>
<img src ="http://www.tkk7.com/fjpan2002/aggbug/81051.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/fjpan2002/" target="_blank">鍕囨暍鐨勫績(jī)</a> 2006-11-14 09:22 <a href="http://www.tkk7.com/fjpan2002/archive/2006/11/14/81051.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>liferay涓殑article銆乻tructure鍜宼emplate涔嬮棿鐨勫叧緋?/title><link>http://www.tkk7.com/fjpan2002/archive/2005/12/30/26018.html</link><dc:creator>鍕囨暍鐨勫績(jī)</dc:creator><author>鍕囨暍鐨勫績(jī)</author><pubDate>Fri, 30 Dec 2005 02:59:00 GMT</pubDate><guid>http://www.tkk7.com/fjpan2002/archive/2005/12/30/26018.html</guid><wfw:comment>http://www.tkk7.com/fjpan2002/comments/26018.html</wfw:comment><comments>http://www.tkk7.com/fjpan2002/archive/2005/12/30/26018.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/fjpan2002/comments/commentRss/26018.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/fjpan2002/services/trackbacks/26018.html</trackback:ping><description><![CDATA[<P>鍦↙iferay鐨凜MS涓璦rticles銆乻tructures鍜宼emplates鏄笁涓噸瑕佺殑姒傚康銆?BR><BR>article錛氬彲浠ラ�氳繃article鏄劇ずLiferay Portal欏甸潰鐨勫唴瀹癸紝濡傞欏甸粯璁ょ殑灝辨槸Home Index榪欎釜article銆?article鍙互鐢眛emplate椹卞姩錛屽嵆article鐨勫唴瀹瑰拰灞曠ず鏍峰紡閮界敱template鎻忚堪鐨剎slt妯℃澘鎵�鍐沖畾錛屽綋鐒禷rticle涔熷彲涓嶇敱template椹卞姩錛岃繖鏃禷rticle鐨勫唴瀹瑰彲浠ョ敱Liferay鍐呯疆鐨凴ich Html Editor緙栧啓錛屼絾鏄彲閲嶇敤鎬ц緝宸�?BR><BR>structure錛氬畾涔変簡(jiǎn)xml鐨勬牸寮忥紙<STRONG><FONT size=2>Schema </FONT></STRONG>錛夛紝瀹冧笌article娌℃湁鐩存帴鐨勫叧鑱旓紝structure琚簲鐢ㄥ埌template涓紝浠庤�屽獎(jiǎng)鍝峚rticle鐨勫唴瀹廣�侺iferay鍙互鍙鍖栧湴緙栬緫<STRONG><FONT size=2>Schema 銆?BR></FONT></STRONG><BR>template錛歛rticle鐨勬ā鏉匡紝鍐沖畾article鐨勫唴瀹瑰拰鏄劇ず鏍峰紡錛屾澶朙iferay榪樺畾涔変簡(jiǎn)涓�浜泃ag錛屽彲浠ユ柟渚垮湴搴旂敤鍒版ā鏉夸腑錛屽"&lt;runtime-portlet name="58" /&gt;",灝辨槸鍦ㄥ姞杞芥ā鏉挎椂鍔ㄦ�佸湴灝哃ogin Portlet鍔犺澆鍒皒ml銆?BR><BR>姝ゅ鍦ㄧ紪鍐檃rticle鎴栬�卼emplate錛岃緭鍏ヤ腑鏂囦細(xì)鏄劇ず涔辯爜錛屾垜浠殑瑙ｅ喅鏂規(guī)硶鏄慨鏀逛簡(jiǎn)Liferay鐨?BR>com.liferay.util.xml.XMLFormatter 鐨則oString()鏂規(guī)硶<BR>鍜宑om.liferay.portlet.journal.util.JournalUtil 鐨則ransform()鏂規(guī)硶<BR>浣跨敤StringWriter鏉ヨ繘琛岃緭鍑猴紝鑰屼笉鏄疊yteArrayOutputStream銆?BR><BR>鍚庤錛氬啓寰楁湁鐐逛貢錛屾榪庢湁鍏磋叮鐨勬湅鍙嬫壒璇勬寚姝ｏ紝浜ゆ祦瀛︿範(fàn)銆?BR><BR></P><img src ="http://www.tkk7.com/fjpan2002/aggbug/26018.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/fjpan2002/" target="_blank">鍕囨暍鐨勫績(jī)</a> 2005-12-30 10:59 <a href="http://www.tkk7.com/fjpan2002/archive/2005/12/30/26018.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Struts+Spring鐨勪笁縐嶆暣鍚堟柟寮忥紙杞級(jí)</title><link>http://www.tkk7.com/fjpan2002/archive/2005/11/28/21627.html</link><dc:creator>鍕囨暍鐨勫績(jī)</dc:creator><author>鍕囨暍鐨勫績(jī)</author><pubDate>Mon, 28 Nov 2005 02:39:00 GMT</pubDate><guid>http://www.tkk7.com/fjpan2002/archive/2005/11/28/21627.html</guid><wfw:comment>http://www.tkk7.com/fjpan2002/comments/21627.html</wfw:comment><comments>http://www.tkk7.com/fjpan2002/archive/2005/11/28/21627.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/fjpan2002/comments/commentRss/21627.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/fjpan2002/services/trackbacks/21627.html</trackback:ping><description><![CDATA[涓�銆佷嬌鐢?nbsp;Spring&nbsp;鐨?nbsp;ActionSupport&nbsp;綾繪暣鍚?nbsp;Structs<BR>浣跨敤&nbsp;Spring&nbsp;鐨?nbsp;DelegatingRequestProcessor&nbsp;瑕嗙洊&nbsp;Struts&nbsp;鐨?nbsp;RequestProcessor&nbsp;灝?nbsp;Struts&nbsp;Action&nbsp;綆＄悊濮旀墭緇?nbsp;Spring&nbsp;妗嗘灦瑁呰澆搴旂敤紼嬪簭鐜<BR>浜屻�佽鐩?nbsp;RequestProcessor<BR>浣跨敤&nbsp;org.springframework.web.struts.DelegatingRequestProcessor&nbsp;綾繪潵瑕嗙洊&nbsp;Struts&nbsp;鐨?nbsp;RequestProcessor&nbsp;澶勭悊紼嬪簭<BR>涓夈�佸皢Action綆＄悊濮旀墭緇?nbsp;Spring<BR><BR>鍘熸枃璇峰弬瑙佲�滀嬌鐢?Spring 鏇村ソ鍦板鐞?Struts 鍔ㄤ綔鈥?BR><BR><A >http://www-128.ibm.com/developerworks/cn/java/j-sr2.html</A><img src ="http://www.tkk7.com/fjpan2002/aggbug/21627.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/fjpan2002/" target="_blank">鍕囨暍鐨勫績(jī)</a> 2005-11-28 10:39 <a href="http://www.tkk7.com/fjpan2002/archive/2005/11/28/21627.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item></channel></rss>                                                                                   <footer>
<div class="friendship-link">
<p>感谢您访问我们的网站，您可能还对以下资源感兴趣：</p>
<a href="http://www.tkk7.com/" title="&#20122;&#27954;&#97;&#118;&#25104;&#20154;&#29255;&#22312;&#32447;&#35266;&#30475;">&#20122;&#27954;&#97;&#118;&#25104;&#20154;&#29255;&#22312;&#32447;&#35266;&#30475;</a>

<div class="friend-links">


</div>
</div>

</footer>

主站蜘蛛池模板：
<a href="http://www789789.com" target="_blank">日本免费大黄在线观看</a>|
<a href="http://2121065.com" target="_blank">久久99精品免费一区二区</a>|
<a href="http://laosanqq.com" target="_blank">美女内射毛片在线看免费人动物
</a>|
<a href="http://sdshfengji.com" target="_blank">永久免费AV无码网站国产</a>|
<a href="http://gxshenquan.com" target="_blank">免费国产高清视频</a>|
<a href="http://8v4y.com" target="_blank">男性gay黄免费网站</a>|
<a href="http://fz166.com" target="_blank">亚洲国产婷婷综合在线精品</a>|
<a href="http://vvihh.com" target="_blank">无遮挡国产高潮视频免费观看</a>|
<a href="http://240842.com" target="_blank">亚洲国产精品无码久久久久久曰</a>|
<a href="http://www12kvkv.com" target="_blank">国产亚洲美女精品久久</a>|
<a href="http://18jko.com" target="_blank">亚洲另类激情专区小说图片</a>|
<a href="http://my533.com" target="_blank">WWW免费视频在线观看播放</a>|
<a href="http://ri9999.com" target="_blank">国产亚洲AV手机在线观看
</a>|
<a href="http://trgod.com" target="_blank">免费亚洲视频在线观看</a>|
<a href="http://yidazn.com" target="_blank">免费一级e一片在线播放</a>|
<a href="http://jaubus.com" target="_blank">ww在线观视频免费观看w</a>|
<a href="http://ccccccx.com" target="_blank">日韩亚洲欧洲在线com91tv</a>|
<a href="http://jmzc888.com" target="_blank">久久99精品国产免费观看</a>|
<a href="http://pencilinside.com" target="_blank">亚洲精品欧洲精品</a>|
<a href="http://dunyny.com" target="_blank">国产精品视频免费一区二区</a>|
<a href="http://789xxoo.com" target="_blank">爱爱帝国亚洲一区二区三区</a>|
<a href="http://yanhx.com" target="_blank">久久精品国产亚洲一区二区三区</a>|
<a href="http://www-135888.com" target="_blank">国产精品网站在线观看免费传媒</a>|
<a href="http://luyifeile.com" target="_blank">亚洲第一精品福利</a>|
<a href="http://cqkalai.com" target="_blank">18禁网站免费无遮挡无码中文</a>|
<a href="http://0415ss.com" target="_blank">亚洲日本天堂在线</a>|
<a href="http://www-741.com" target="_blank">亚洲人成无码久久电影网站</a>|
<a href="http://6266tv.com" target="_blank">午夜影院免费观看</a>|
<a href="http://zibochanglong.com" target="_blank">亚洲不卡中文字幕</a>|
<a href="http://3atv66.com" target="_blank">亚洲国产香蕉人人爽成AV片久久</a>|
<a href="http://714747.com" target="_blank">久久久久免费精品国产</a>|
<a href="http://89895cc.com" target="_blank">亚洲制服在线观看</a>|
<a href="http://bj-tkld.com" target="_blank">亚洲人午夜射精精品日韩</a>|
<a href="http://bxd888.com" target="_blank">免费女人高潮流视频在线观看</a>|
<a href="http://zzdyzj.com" target="_blank">在线a亚洲老鸭窝天堂av高清</a>|
<a href="http://805ios.com" target="_blank">亚洲区不卡顿区在线观看</a>|
<a href="http://www19977.com" target="_blank">日韩av无码久久精品免费</a>|
<a href="http://www-75044.com" target="_blank">亚洲欧美成人一区二区三区</a>|
<a href="http://xx2015.com" target="_blank">亚洲欧洲国产精品香蕉网</a>|
<a href="http://yy6767.com" target="_blank">两个人的视频高清在线观看免费
</a>|
<a href="http://mt569.com" target="_blank">亚洲午夜电影在线观看高清</a>|
<script>
(function(){
    var bp = document.createElement('script');
    var curProtocol = window.location.protocol.split(':')[0];
    if (curProtocol === 'https') {
        bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
    }
    else {
        bp.src = 'http://push.zhanzhang.baidu.com/push.js';
    }
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(bp, s);
})();
</script>
</body>