ÇóÖúOracle XeÏà¹ØÎÊÌâ - MS-SQL Server / ·Ç¼¼Êõ°æ
ÎÒµÄOracle XeÕâ¸öÈí¼þ²»ÄÜÓÃÁË£¬È»ºóÐ¶ÔØÁË£¬ÎÒÖØÐ°²×°£¬¿ÉÊǵçÄÔÌáʾϵͳÉÏÓÐÁË´Ë·þÎñ£¬ÕâÊÇÔõô»ØÊ°¡£¿
Ð¶ÔØ²»ÍêÈ«£¿ ²»Ã÷ ÓÑÇéUPÒýÓà ÎÒµÄOracle XeÕâ¸öÈí¼þ²»ÄÜÓÃÁË£¬È»ºóÐ¶ÔØÁË£¬ÎÒÖØÐ°²×°£¬¿ÉÊǵçÄÔÌáʾϵͳÉÏÓÐÁË´Ë·þÎñ£¬ÕâÊÇÔõô»ØÊ°¡£¿ Ð¶ÔØ²»ÍêÈ«,ÐèÒªµ½×¢²á±íÖÐȥɾ³ýÈçϵÄÄÚÈÝ. 1. hkey_local_machine\softwareÏÂ,oracleĿ¼. hkey_local_machine\system\controlset001\servicesÏÂ,ËùÓÐoracleÏî. hkey_local_machine\system\controlset002\servicesÏÂ,ËùÓÐoracleÏî. hkey_local_machine\system\currentcontrolset\servicesÏÂ,ËùÓÐoracleÏî. hkey_classs_rootÏÂ,ËùÓÐoracleÏî. 2. ɾ³ýoracle°²×°Îļþ. ϵͳĿ¼ÏÂ,program filesÎļþ¼ÐÖеÄoracleÎļþ. 3.ÖØÐ°²×°. ллඣ¬ÒѾ°²×°³É¹¦
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......