Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

jspÁ¬½Óoracle³öÏÖµÄÎÊÌâ

    ½ñÌìµÚÒ»´ÎʹÓÃoracleÊý¾Ý¿âÀ´×ö¶«Î÷¡£¿ÉÊÇÈ´Óöµ½ÁËÂé·³£¡¾ßÌåÁ¬½ÓÊý¾Ý¿âµÄ´úÂëÊÇÔÚÍøÉÏ¿´µÄ¡£

    Á¬½Ó´úÂëÈçÏ£º
    <%
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
      String url= ......

ORACLE,ÎÒÀ´ÁË£¡

Ï£Íû´ó¼Ò¶à¶à¹ØÕÕ£¡

hehe

½Ó·Ö£¬ding

OK !
jf



»¶Ó­...

»¶Ó­»¶Ó­~



²äµã·Ö¡£

ǰʮ»¶Ó­

ͬ¥ÉÏ

°³À´´Õ¸öÈÈÄÖ¡£¡£
Ö¨¸öÉù£¬»¶Ó­Â¥Ö÷¡£¡£

Õâ¸öÉç»á±¾À´¾ÍÊÇÓÃÀ´¹²Í¬Ñ§Ï°µÄµØ·½¡£
  ÈËÔ½¶àÔ½ºÃ°¡£¡
    »¶Ó­£¡

ÒýÓÃ
Õâ¸öÉç»á±¾À´¾ÍÊÇÓÃÀ´¹²Í¬Ñ§Ï ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL

ÒòΪÄã°ÑÎļþ¼Ð¿´´íÁ˰ɡ£

´ó¸ç£¬Èç¹û²»ÊÇÄãÑÛ»¨µÄ»°£¬ÄÇ¿ÉÄܾÍÊÇÄã½ø´íµØ·½ÁË¡£

ÓÃÈýÂ¥µÄ·½·¨²éÒ ......

C# ÏòoracleÊý¾Ý¿â²åÈë¸üеÄËÙ¶ÈÎÊÌâ

Ïò´ó¼ÒÇë½ÌÒ»¸öÎÊÌâ

  C# ÏòoracleÊý¾Ý¿â²åÈ룬ÈçºÎÄÜÈ¥Ìá¸ßЧÂÊ£¿£¿£¿

ÎÒÏÖÔÚ²åÈëÊý¾Ý¿âµÄÊÇÿ5Ãë²åÈëºÍ¸üУ¬Ã¿´Î²åÈëºÍ¸üеÄÊýÄ¿´ó¸ÅÓÐ300Ìõ¼Ç¼×óÓÒ£¡£¡²¢ÇÒÊÇÓöàÏß³Ìͬʱȥ²åÈëºÍ¸üÐÂ

OracleµÄÈÕÖ¾»á²»»áÀÛ»ýÏÂÀ´£¬¶ø»áµ¼Ö²åÈëµÄЧÂʵģ¿

  OracleÊDz»ÊÇÓÐÒ»¸ö²¢ÐвåÈëºÍ¸ü ......

ORACLE¹ØÓÚsqlÓï¾äÓÅ»¯ÎÊÌâ

Óõ½ÈçÏÂÓï¾ä£º
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 ......

mysqlµÄÍâÁ¬½ÓÓÐûÓÐÀàËÆÓÚoracle ¼ÓºÅµÄд·¨?

ÒòΪһЩsqlÓï¾äÊǸù¾ÝÌõ¼þÅжϽøÐÐÆ´×°µÄ...

ÓÐЩÇé¿öÐèÒªÍâÁ¬½Ó,ÓÐЩÇé¿ö²»ÐèÒª,

ÔËÐÐʱ²»ÄÜÈ·¶¨ÊÇ·ñÐèÒªÍâÁ¬½Ó,
mysqlÓÐûÓÐÀàËÆÓÚoracle £¨+£©µÄд·¨£¿
¼´Ç°Ãæ¿ÉÒÔ²»Ð´ LEFT OUTER JOIN ¶øÇÒÒ²²»Óýô¸ú×Åfrom table дON


ûÓУ¬×îºÃÓñê×¼µÄSQLÓï·¨

(+) ÊÇORACLEÌØÓÐÁË£¬ÀàËÆµÄ»¹ÓÐ (* ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [216] [217] [218] [219] 220 [221] [222] [223] [224] [225]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ