½ñÌìµÚÒ»´ÎʹÓÃoracleÊý¾Ý¿âÀ´×ö¶«Î÷¡£¿ÉÊÇÈ´Óöµ½ÁËÂé·³£¡¾ßÌåÁ¬½ÓÊý¾Ý¿âµÄ´úÂëÊÇÔÚÍøÉÏ¿´µÄ¡£
Á¬½Ó´úÂëÈçÏ£º
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url= ......
Ï£Íû´ó¼Ò¶à¶à¹ØÕÕ£¡
hehe
½Ó·Ö£¬ding
OK !
jf
»¶Ó...
»¶Ó»¶Ó~
²äµã·Ö¡£
ǰʮ»¶Ó
ͬ¥ÉÏ
°³À´´Õ¸öÈÈÄÖ¡£¡£
Ö¨¸öÉù£¬»¶ÓÂ¥Ö÷¡£¡£
Õâ¸öÉç»á±¾À´¾ÍÊÇÓÃÀ´¹²Í¬Ñ§Ï°µÄµØ·½¡£
ÈËÔ½¶àÔ½ºÃ°¡£¡
»¶Ó£¡
ÒýÓÃ
Õâ¸öÉç»á±¾À´¾ÍÊÇÓÃÀ´¹²Í¬Ñ§Ï ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
ÒòΪÄã°ÑÎļþ¼Ð¿´´íÁ˰ɡ£
´ó¸ç£¬Èç¹û²»ÊÇÄãÑÛ»¨µÄ»°£¬ÄÇ¿ÉÄܾÍÊÇÄã½ø´íµØ·½ÁË¡£
ÓÃÈýÂ¥µÄ·½·¨²éÒ ......
Ïò´ó¼ÒÇë½ÌÒ»¸öÎÊÌâ
C# ÏòoracleÊý¾Ý¿â²åÈ룬ÈçºÎÄÜÈ¥Ìá¸ßЧÂÊ£¿£¿£¿
ÎÒÏÖÔÚ²åÈëÊý¾Ý¿âµÄÊÇÿ5Ãë²åÈëºÍ¸üУ¬Ã¿´Î²åÈëºÍ¸üеÄÊýÄ¿´ó¸ÅÓÐ300Ìõ¼Ç¼×óÓÒ£¡£¡²¢ÇÒÊÇÓöàÏß³Ìͬʱȥ²åÈëºÍ¸üÐÂ
OracleµÄÈÕÖ¾»á²»»áÀÛ»ýÏÂÀ´£¬¶ø»áµ¼Ö²åÈëµÄЧÂʵģ¿
OracleÊDz»ÊÇÓÐÒ»¸ö²¢ÐвåÈëºÍ¸ü ......
Óõ½ÈçÏÂÓï¾ä£º
select A,B,C from tableName where
TO_CHAR(A,'yyyy-MM-dd') like '2009-11-09' and B = '600' and A = (select max(A) from tableName where B = '600')
or TO_CHAR(A,'yyyy-MM-dd') like '2009-11-09' and B = '603' and A = (select ......
ÒòΪһЩsqlÓï¾äÊǸù¾ÝÌõ¼þÅжϽøÐÐÆ´×°µÄ...
ÓÐЩÇé¿öÐèÒªÍâÁ¬½Ó,ÓÐЩÇé¿ö²»ÐèÒª,
ÔËÐÐʱ²»ÄÜÈ·¶¨ÊÇ·ñÐèÒªÍâÁ¬½Ó,
mysqlÓÐûÓÐÀàËÆÓÚoracle £¨+£©µÄд·¨£¿
¼´Ç°Ãæ¿ÉÒÔ²»Ð´ LEFT OUTER JOIN ¶øÇÒÒ²²»Óýô¸ú×Åfrom table дON
ûÓУ¬×îºÃÓñê×¼µÄSQLÓï·¨
(+) ÊÇORACLEÌØÓÐÁË£¬ÀàËÆµÄ»¹ÓÐ (* ......