[杞琞瑙ｆ瀽oracle鐨凴OWNUM — 浣滆: chen_liang
瀵逛簬rownum鏉ヨ瀹冩槸oracle绯荤粺椤哄簭鍒嗛厤涓轰粠鏌ヨ杩斿洖鐨勮鐨勭紪鍙凤紝杩斿洖鐨勭涓琛屽垎閰嶇殑鏄1锛岀浜岃鏄2锛屼緷姝ょ被鎺紝杩欎釜浼瓧娈靛彲浠ョ敤浜庨檺鍒舵煡璇㈣繑鍥炵殑鎬昏鏁帮紝鑰屼笖rownum涓嶈兘浠ヤ换浣曡〃鐨勫悕绉颁綔涓哄墠缂銆
涓句緥璇存槑锛 (Read more…)
EXECUTE IMMEDIATE鐢ㄦ硶灏忚В
EXECUTE IMMEDIATE 浠ｆ浛浜嗕互鍓峅racle8i涓璂BMS_SQL package鍖.
瀹冭В鏋愬苟椹笂鎵ц鍔ㄦ佺殑SQL璇彞鎴栭潪杩愯鏃跺垱寤虹殑PL/SQL鍧.鍔ㄦ佸垱寤哄拰鎵цSQL璇彞鎬ц兘瓒呭墠锛孍XECUTE IMMEDIATE鐨勭洰鏍囧湪浜庡噺灏忎紒涓氳垂鐢ㄥ苟鑾峰緱杈冮珮鐨勬ц兘锛岃緝涔嬩互鍓嶅畠鐩稿綋瀹规槗缂栫爜.灏界DBMS_SQL浠嶇劧鍙敤锛屼絾鏄帹鑽愪娇鐢‥XECUTE IMMEDIATE,鍥犱负瀹冭幏鐨勬敹鐩婂湪鍖呬箣涓娿
鏃犻渶鐧诲綍淇敼Oracle鐢ㄦ埛瀵嗙爜
濡傛灉浣犱笉璁板緱浜唎racle鐢ㄦ埛鐨勫瘑鐮,鎴戜滑鍙互杩欐牱杩涜閲嶆柊璁剧疆:
鍦ㄥ懡浠よ鎵ц濡備笅鍛戒护锛
sqlplus “/@鏈嶅姟鍚 as sysdba”
鐒跺悗鍦╯qlplus涓
(Read more…)
NO_DATA_FOUND鍜%NOTFOUND鐨勫樊鍒
涓鑸垵瀛﹁呭Oracle 鐨凬O_DATA_FOUND 鍜%NOTFOUND 涓や釜淇濈暀瀛楃殑鐢ㄦ硶涓嶅浜 瑙ｏ紝涓昏鏄畠浠粠鎰忎箟涓婃槸鏈変簺绫讳技銆傚叾瀹炲畠浠殑鐢ㄦ硶鏄湁鍖哄埆鐨勶紝灏忕粨濡備笅锛
1 SELECT . . . INTO 璇彞瑙﹀彂 NO_DATA_FOUND锛
2 褰撲竴涓樉绀哄厜鏍囩殑 where 瀛愬彞鏈壘鍒版椂 瑙﹀彂 %NOTFOUND锛
(Read more…)
Tags : %NOTFOUND, NO_DATA_FOUND, oracle
Oracle鎻掑叆鍥炶溅鎹㈣绗
-
SQL>create TABLE t(abc varchar2(100));
-
-
琛ㄥ凡鍒涘缓銆
-
-
SQL>insert INTO t(abc) VALUES('abcdef'||chr(10)||chr(13)||'hjkml');
-
-
宸插垱寤 1 琛屻
-
-
SQL>select * FROM t;
-
-
ABC
-
-
abcdef
-
-
hjkml
Oracle鏌ヨ琛ㄥ悕鍙婃ā绯婃煡璇
绀轰緥锛
-
SELECT table_name,tablespace_name,TEMPORARY
-
FROM user_tables
-
WHERE table_name LIKE '%PROV%'
鍒嗘瀽锛
銆銆table_name:琛ㄥ悕锛坴archar2(30)锛;
銆銆tablespace_name:瀛樺偍琛ㄥ悕鐨勮〃绌洪棿锛坴archar2锛30锛夛級锛
(Read more…)
鈥滅櫨搴︾粺璁♀濊缃戠珯杩愯惀鎺ㄥ箍鏈夎抗鍙惊
銆銆鈥滄嵁涓浗浜掕仈缃戠粶淇℃伅涓績(CNNIC)鏁版嵁缁熻锛屼腑鍥界殑缃戠珯鏁伴噺宸茶揪鍒306涓囦釜锛岀浉姣1998骞寸殑3700瀹讹紝12骞翠腑澧為暱浜827鍊嶏紝蹇熷礇璧风殑搴炲ぇ缃戠珯缇や綋锛屾垚涓轰腑鍥戒簰鑱旂綉鍙戝睍涓嶅彲蹇借鐨勬帹鍔ㄥ姏閲忋傗
銆銆鍦ㄦ棩娓愬叴璧风殑缃戠珯娴锋磱涓紝缁濆ぇ澶氭暟绔欓暱瀵圭綉绔欑殑杩愯惀璁宠帿濡傛繁锛屽骞垮憡鏀剁泭鍜屽浣曟敼鍠勭綉绔欎綋楠屽苟娌℃湁涓涓竻鏅扮殑鎬濊矾銆備箣鎵浠ュ瓨鍦ㄨ繖鏍风殑闂锛屽叾鏍规湰鍘熷洜鍦ㄤ簬缃戠珯杩愯惀鏁版嵁鐨勬贩涔憋紝鑰岃濡傜綉绔欐棩娴侀噺銆佺敤鎴风殑鍏虫敞鐐广佽闂噺鏈楂橀〉闈㈢瓑閮介渶瑕佸噯纭佹竻鏅扮殑鏁版嵁鍋氭敮鎾戙傚鏋滄病鏈変竴涓灏界殑鏁版嵁缁熻锛岀綉绔欑殑鍙戝睍灏嗕細鏆楄棌宸ㄥぇ鐨勫喅绛栭闄╋紝姝ｆ墍璋撶綉绔欏彂灞曟暟鎹繀鍏堣锛岃岃繖锛屽氨闇瑕佸姛鑳藉己澶х殑鏁版嵁缁熻骞冲彴銆傗滅櫨搴︾粺璁♀濅究鏄繖鏍蜂竴娆剧畝鍗曟槗鐢ㄣ佺豢鑹插彲渚濊禆銆佽兘澶熸弧瓒充釜鎬у寲缁熻闇姹傜殑涓撲笟缃戠珯娴侀噺鍒嗘瀽宸ュ叿銆
(Read more…)
鐏嫄Firefox浜斿懆宀 璁板綍浜掕仈缃戝法鍙樹簲杞
鐏嫄娴忚鍣ㄥ凡缁忎簲鍛ㄥ瞾浜嗐傛垜浠笇鏈涢氳繃涓璧锋潵鍥為【涓涓嬭繖浜斿勾閲屼簰鑱旂綉绌剁珶鍙戠敓浜嗗摢浜涘彉鍖栦互鍙婄伀鐙愬湪杩欎簲骞撮噷鐨勫彂灞曟潵涓璧峰簡绁濊繖娆＄敓鏃ャ
鎴戜滑鐜板湪鐨勫湴鏂?
銆銆2009骞存槸闈炲父鏈夎叮鐨勪竴骞淬傛垜浠鍦ㄤ簰鑱旂綉鐨勫崄瀛楄矾鍙ｄ笂銆傚湪鎺ヤ笅鏉ョ殑12涓湀閲岄潰鎴戜滑灏嗕竴璧风洰鐫瑰湪浜掕仈缃戞柟闈㈢殑鍙戝睍鍜屽彉鍖栤攢鈹鍙兘鏄ソ鐨勫彉鍖栵紝涔熷彲鑳芥槸涓嶅ソ鐨勩傛垜浠凡缁忕湅鍒颁簡鍦ㄦ祻瑙堝櫒涓栫晫涓秺鏉ヨ秺澶氱殑鍏虫敞锛孏oogle涔熷姞鍏ュ苟缁欐垜浠甫鏉ョ殑浠栦滑闈炲父绠娲佺殑Chrome娴忚鍣ㄣ侻ozilla閫氳繃鍙戝竷鐏嫄3.5鎶婁竴涓ц兘鎻愬崌宸ㄥぇ鐨勬覆鏌撳紩鎿庡甫鍒颁簡涓婄櫨涓囩殑鐢ㄦ埛鎵嬩腑銆傛鐩熸鍦ㄥ悓寰蒋鍗忚皟鏉ュ疄鐜扮敤鎴峰湪鎿嶄綔绯荤粺涓娴忚鍣ㄨ繘琛岄夋嫨鐨勬柟妗堛傛病鏈変汉鐜板湪鍙互璇磋繖浜涘お鏃犺亰浜嗐傝岃繖涓鍒囬兘鍙戠敓鍦ㄨ繃鍘荤殑涓骞撮噷闈€
(Read more…)
鐢查鏂囩粓浜庨忛湶瀵筍UN鍏徃鍚勪釜鎶鏈拰浜у搧鐨勭瓥鐣
鐢查鏂囧湪鏃ュ墠鍙戝竷鐨勪竴浠紽AQ涓粓浜庨忛湶浜嗗SUN鍏徃鍚勪釜鎶鏈拰浜у搧鐨勭瓥鐣ワ紝鍏朵腑鍖呮嫭浜哊etBeans锛孏lassfish锛孫penOffice鍜 VirtualBox绛塖UN鐨勪骇鍝併備箣鍓嶅ぇ瀹跺叧蹇冪殑MySQL锛孲PARC鍜孲olaris閮藉凡缁忛噸鐢宠繃澶氭浜嗭紝浣嗗杩欏嚑涓骇鍝佺殑绛栫暐杩欒繕鏄涓娆￠忔紡銆備笅闈㈡潵鐪嬬湅鐢查鏂囧杩欏嚑涓骇鍝佺殑鏈潵瑙勫垝鍚с
銆銆NetBeans
銆銆鐢查鏂囨墦绠楀皢NetBeans浣滀负 JDeveloper鍜孫racle Enterprise Pack for Eclipse鐨勨滈澶栫殑寮婧愰夋嫨鈥濓紝鐢查鏂囬潪甯告竻妤氾紝JDeveloper鎵嶆槸Oracle铻嶅悎鏈潵浼佷笟绾у紑鍙戠殑鎴樼暐鎬у紑鍙戝伐鍏枫傜敳楠ㄦ枃琛ㄧずJDeveloper锛孍nterprise Pack鍜 NetBeans閮藉皢鏄疛ava鍜孞avaEE寮鍙戠殑鏈夋晥閫夋嫨銆
(Read more…)
google sitemap鍦ㄧ嚎鐢熸垚宸ュ叿
濡備綍璁╀綘鐨勭綉绔欐洿蹇洿澶氱殑琚玤oogle鍜岄泤铏庢敹褰?閭ｅ氨鏄埗浣済oogle sitemap鍦板浘,鍒朵綔yahoo urllist.txt缁 google鍜岄泤铏庢敹褰曟彁渚涘缓璁,xml-sitemaps.com鏄竴涓湪绾跨敓鎴,鍒朵綔google sitamap鐨勫伐鍏风綉绔欏拰鍦ㄧ嚎鐢熸垚 yahoo urllist.txt FEED鐨勭綉绔.
google sitemap鍦ㄧ嚎鍒朵綔宸ュ叿,google sitemap鍦ㄧ嚎鐢熸垚宸ュ叿
http://www.xml-sitemaps.com
鍏嶈垂鐢熸垚500涓猽rl,濡傛灉瑕佺敓鎴愬畬鍏ㄧ殑,闇瑕佷粯璐,瀵逛簬涓涓皬绔欐潵璇,鍏堟敹褰5鐧鹃〉涔熸槸涓嶉敊鐨勪富鎰,鐢熸垚閫熷害鏈夌偣鎱,浣犲彲瑕佽愭х瓑寰呬竴涓
(Read more…)