Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÍÆ¼ö¼¸±¾Ñ§Ï°OracleµÄÊé

»ù´¡µÄ
Öм¶µÄ
¸ß¼¶µÄ
лл£¡
ÖÐÎÄÊé¼®£º
»ù´¡µÄ: Êý¾Ý¿âϵͳ¸ÅÂÛ¡¢oracle 9iÖÐÎİæ»ù´¡Åàѵ½Ì³Ì¡¢SQL21×Ôѧͨ
Öм¶µÄ£º¾«Í¨Oracle 10g PL/SQL±à³Ì
¸ß¼¶µÄ£ºOracle 9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹¡¢Oracleר¼Ò¸ß¼¶±à³Ì

Ó¢ÎÄÊé¼®£º
  »ù´¡µÄ£ºPLSQL_UserGuide¡¢plsql reference¡¢
  Öм¶µÄ£ºOReilly SQL Cookbook
  ¸ß¼¶µÄ£ºOracle Database 11g DBA¡¢performance turning guide

¡£¡£¡£¡£

  »¹Óкܶ࣬ÔÝÁоÙÁËÕâЩ£¡




¸Õ²Å»¹ÓиöÌû×ÓÂôÊéµÄ,ºÃЩORACLEµÄÊé¶¼²»´í

ÓÊÏä¶àÉÙѽ£¬ÎÒǰ²»¾ÃÇó¹ýµç×ÓÊ飬·ÖÏí¸øÄã¡£

ÒýÓÃ
ÓÊÏä¶àÉÙѽ£¬ÎÒǰ²»¾ÃÇó¹ýµç×ÓÊ飬·ÖÏí¸øÄã¡£

aspnetzq@gmail.com
ллÁË£¡



´ó»°Oracle RAC

Ò»¸ö´óÅ£µÄ·Ïߣº

µÚÒ»½×¶ÎÍÆ¼öÊé¼®£º
ͨ¹ýǰÁ½²½µÄѧϰ£¬¶ÔOracleÊý¾Ý¿âÒѾ­ÓÐÁ˳õ²½µÄÁ˽⣬ÐèҪϵͳѧϰÀ´ÌáÉý×ÔÎÒ
Oracle Concepts
Oracle Database Reference
ÔĶÁ½×¶ÎµÄʵ¼ù²Ù×÷Ê®·ÖÖØÒª
Êé±¾ÉϵÄ֪ʶֻÓÐͨ¹ýʵ¼ù²ÅÄܳÉΪ×Ô¼ºµÄ
ͨ¹ýʵ¼ù²Ù×÷À´Ñ§Ï°ÀíÂÛ
ʵ¼ùÄܰѿÝÔïµÄÔĶÁ±äµÃÇáËÉ
http://www.oraclefans.cn/forum/showtopic.jsp?rootid=3053&CPages=1 ; ´ÓÁ㿪ʼ-ORACLE 9IÈëÃÅ

µÚ¶þ½×¶ÎÍÆ¼öÊé¼®£º
Oracle 10GÐÔÄܵ÷ÓÅ (Oracle¹Ù·½Îĵµ)
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Richmond Shee)
Oracle8i Internal Services fo


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ