Çó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ÀïÃæÓеÄÊÇÎĵµ
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
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 ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......