oracleÓëmysqlµÄÇø±ð
ËÓÐoracleÓëmysql µÄÇø±ð×ÊÁÏ
Ê²Ã´Çø±ð?
Óï·¨?
¹æÄ£?
Ó¦Óò¿Êð?
½á¹¹?
......ÄãÕâ¸ö·¶Î§Ò²Ì«´óÁ˰É
¾ÍÊÇOracleÖÐÓеĺ¯Êý£¬¶øÔÚmysqlÖÐûÓУ¬Ò²²»ÄÜÓõİ¡
ËûÃÇÖ®¼ä±ê×¼SQL99¶¼Ö§³ÖµÄ,ORACLE×Ô¼ºµÄPL/SQLÊÇÔÚSQLÉÏ×öÀ©Õ¹,
ºÜ¶àº¯ÊýûÓÐ,ûÓÐ×ö¹ý×ܽᰡ,ÀýÈçWM_CONCAT(),ROW_NUMBER(),DUMP()¶àÁËÈ¥ÁË,µÈ......
ѧϰһÏÂ
http://blog.csdn.net/shiyuntian_wang/archive/2009/10/14/4671813.aspx
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
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 ÕýÈ ......