ÇóoracleÎĵµ½éÉÜ£¬Ê¹ÓÃÖ¸ÄÏ - Oracle / »ù´¡ºÍ¹ÜÀí
±¾È˸ã±à³ÌµÄ£¬ËùÒÔ¶ÔÊý¾Ý¿â²»ÊǺÜרҵ¡£
µ«ÊÇѧ¹ý»ù±¾µÄsql£¬¶ÔoracleµÄsqlplusÒ²¿´¹ýÊÓÆµ£¬Ö»ÊÇÁ˽â
ËùÒÔÎÒÏëÖªµÀoracleÓÐʲôÎĵµÖ®ÀàµÄ£¬ÀàËÆÓÚÎÒÃÇjavaseÓÐapi£¬»òÕßʹÓÃÖ¸ÄÏÒ²¿ÉÒÔ¡£
·½±ã²éÕÒ¶«Î÷£¬£¨×îºÃÁ¬ÄÇÖÖ»ù±¾Êý¾ÝÀàÐ͵ÄÖ¸ÄÏÓÐÓУ©
¹Ù·½Îĵµ¶¼ÊÇEÎĵģ¬Â¥ÉÏÁ½Î»¶¼ÊÇÇ¿ÈËѽ
¶þÂ¥ÕâλÈÊÐÖÍÆ¼öµÄÄǸöÌ«´óÁ衃 400¶àMB
ËùÒÔÎÒÁíÍâÕÒÁËһϣ¬ÕÒµ½ÕâЩ
*************************
Oracle Database SQL Language Reference
È«Ãæ½éÉÜSQLÓïÑÔ¡£´ËÎĵµÎÞÐ辫¶Á£¬Åöµ½²»¶®µÄµØ·½²é¿´´ËÎÄ µµ¼´¿É
Oracle Database PL/SQL Language Reference
È«Ãæ½éÉÜPL/SQL±à ³ÌÓïÑÔ¡£´ËÎĵµÎÞÐ辫¶Á£¬Åöµ½²»¶®µÄµØ·½²é¿´´ËÎĵµ¼´¿É
Oracle Database PL/SQL Packages and Types Reference
Õâ¸öÎĵµÈ«Ãæ½éÉÜORACLEÊý¾Ý¿âÖÐÄÚÖõÄPL/SQL°üºÍÀàÐÍ£¬Èç±È½Ï³£ÓõÄÒÔ CTX_(ORACLE TEXTÏà¹ØµÄ°ü)DBMS_(ORACLEÊý¾Ý¿â¹ÜÀíÏà¹ØµÄ°ü),UTL_(ORACLEʵÓù¤¾ßÏà¹ØµÄ°ü)
SQL*Plus User's Guide and Reference
Õâ¸öÎĵµ½éÉÜORACLE³£ÓõĿͻ§¶Ë¹¤¾ßSQL*PlusµÄʹÓÃ
******************
Õ⼸±¾¿´ÆðÀ´Ò²Í¦²»´íµÄ£¿£¿¶øÇÒ¶¼Êǹٷ½µÄ
400MÄÄÀïËã´ó£¬ÏÂÔØµÄÎĵµÀïÓкܶ౾ÊéµÄ£¬ÄãдµÄ¶¼°üÀ¨ÔÚÆäÖÐ
ÔÀ´Èç´Ë
Å£±Æ£¬·Ç³£¸Ðл£¡
û¿´¹ý¡£
www.oracle.orgÀïÃæÓеÄÊÇÎĵµ
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......