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

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


Ïà¹ØÎÊ´ð£º

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 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

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

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

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ