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

OracleÊý¾Ý¿â10g²úƷϵÁÐ

×÷ΪoracleµÄÏúÊÛÕæÐÄÕæÒâµÄÔ­ÒâÓë´ó¼Ò·ÖÏíoracleµÄÒ»ÇУ¬ÎÒÕâ±ß²»ÊÇÇþµÀ£¬ÊÇoracle×ÊÉî×Ü´úÀí£¨ÖйúÈí¼þÓë¼¼Êõ·þÎñ¹É·ÝÓÐÏÞ¹« ¿Í»§¾­Àí 15010529916 ÕÔÌìÊæ£©£¬Ï£Íû´ó¼ÒÓйºÂòoracleÒâÔ¸µÄʱºò¼ÇµÃÎÒ£¬ÎһᾡÎÒËùÄܵİïÖú´ó¼Ò¡£
 
OracleÊý¾Ý¿â10g²úƷϵÁÐ
Oracle °×ƤÊé
 
 
Oracle Database 10g ²úƷϵÁÐ
ÒýÑÔ
Oracle Database 10g ÌṩÁËËĸö°æ±¾£¬Ã¿¸ö°æ±¾ÊÊÓÃÓÚ²»Í¬µÄ¿ª·¢ºÍ²¿Êð»·¾³¡£Oracle »¹ÌṩÁ˶îÍâµÄ¼¸ÖÖ¿ÉÑ¡Êý¾Ý¿â²úÆ·£¬ÕâЩ²úÆ·Õë¶ÔÌØÊâµÄÓ¦ÓÃÐèÇóÔöÇ¿ÁË Oracle Database 10g µÄ¹¦ÄÜ¡£ÏÂÃæÊÇ Oracle Database 10g µÄ¿ÉÓð汾£º
       (1) OracleÊý¾Ý¿â10g±ê×¼°æ1£¨Oracle Database 10g Standard Edition One £©Îª¹¤×÷×é¡¢²¿Ãż¶ºÍ»¥ÁªÍø/ÄÚÁªÍøÓ¦ÓóÌÐòÌṩÁËǰËùδÓеÄÒ×ÓÃÐÔºÍÐÔÄܼ۸ñ±È¡£´ÓÕë¶ÔСÐÍÉÌÎñµÄµ¥·þÎñÆ÷»·¾³µ½´óÐ͵ķֲ¼Ê½²¿ÃÅ»·¾³£¬Oracle Database 10g Standard Edition °üº¬Á˹¹½¨¹Ø¼üÉÌÎñµÄÓ¦ÓóÌÐòËù±ØÐèµÄÈ«²¿¹¤¾ß¡£Standard Edition One ½öÐí¿ÉÔÚ×î¸ßÈÝÁ¿ÎªÁ½¸ö´¦ÀíÆ÷µÄ·þÎñÆ÷ÉÏʹÓá£
       (2)OracleÊý¾Ý¿â10g±ê×¼°æ£¨Oracle Database 10g Standard Edition £© ÌṩÁË Standard Edition One µÄǰËùδÓеÄÒ×ÓÃÐÔ¡¢ÄÜÁ¦ºÍÐÔÄÜ£¬²¢ÇÒÀûÓÃÕæÕýÓ¦Óü¯ÈºÌṩÁ˶Ըü´óÐ͵ļÆËã»úºÍ·þÎñ¼¯ÈºµÄÖ§³Ö¡£Ëü¿ÉÒÔÔÚ×î¸ßÈÝÁ¿ÎªËĸö´¦ÀíÆ÷µÄµ¥Ì¨·þÎñÆ÷ÉÏ¡¢»òÕßÔÚÒ»¸öÖ§³Ö×î¶àËĸö´¦ÀíÆ÷µÄ·þÎñÆ÷µÄ¼¯ÈºÉÏʹÓá£
        (3)OracleÊý¾Ý¿â10gÆóÒµ°æ£¨Oracle Database 10g Enterprise Edition £©Îª¹Ø¼üÈÎÎñµÄÓ¦ÓóÌÐò£¨Èç´óÒµÎñÁ¿µÄÔÚÏßÊÂÎñ´¦Àí (OLTP) »·¾³¡¢²éѯÃܼ¯µÄÊý¾Ý²Ö¿âºÍÒªÇó¿Á¿ÌµÄ»¥ÁªÍøÓ¦ÓóÌÐò£©ÌṩÁ˸ßЧ¡¢¿É¿¿¡¢°²È«µÄÊý¾Ý¹ÜÀí¡£Oracle Êý¾Ý¿âÆóÒµ°æÎªÆóÒµÌṩÁËÂú×ãµ±½ñ¹Ø¼üÈÎÎñÓ¦ÓóÌÐòµÄ¿ÉÓÃÐԺͿÉÉìËõÐÔÐèÇóµÄ¹¤¾ßºÍ¹¦ÄÜ¡£Ëü°üº¬ÁË Oracle Êý¾Ý¿âµÄËùÓÐ×é¼þ£¬²¢ÇÒÄܹ»Í¨¹ý¹ºÂòÑ¡ÏîºÍ³ÌÐò°ü£¨±¾ÎÄÉԺ󽫼ÓÒÔ˵Ã÷£©À´½øÒ»²½µÃµ½ÔöÇ¿¡£
        (4)OracleÊý¾Ý¿â10g¸öÈ˰棨Oracle Database 10g Personal Edition£© Ö§³ÖÐèÒªÓëOracleÊý¾Ý¿â10g±ê×¼°æ1¡¢Oracle Êý¾Ý¿â±ê×¼°æºÍ Oracle Êý¾Ý¿âÆóÒµ°æÍêÈ«¼æÈݵĵ¥Óû§¿ª·¢ºÍ²¿Êð¡£Í¨¹ý½« Oracle Database 10g µÄ»ñ½±µÄ¹¦ÄÜÒýÈëµ½¸öÈ˹¤×÷Õ¾ÖУ¬Oracle Ìṩ½áºÏÁËÊÀ½çÉÏ×îÁ÷ÐеÄÊý¾Ý¿â¹¦ÄܵÄÊý¾Ý


Ïà¹ØÎĵµ£º

[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......

oracleµ÷ÓÃjava³ÌÐòÁ¬sqlserver2005

1¡¢ÔÚoracleµÄsys-sysdbaϵǽ
дһ¸öjava source³ÌÐòÁ´½Ósqlserver2005£º
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
    public static String entry ......

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð

ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:select floor(-1.001) value
¡¡¡¡O:select floor(-1.001) valu ......

oracleÓësqlserverÖ´ÐÐcount(*)·µ»ØµÄ½á¹û¼æÈÝ

ÓÉÓÚÒÔǰ¶¼ÊÇÔÚsqlserver 2005´¦Àí£¬ÏÖÔÚ¿Í»§ÒªÇóoracleÊý¾Ý¿â·þÎñÆ÷£¬
×î³õµÄ´úÂëΪ£º
allRecordSize = (Integer) rs1.getObject(1);    //Integer allRecordSize=0;
µ±Ö´ÐеÄʱºò±¨£ºBigDecimalÎÞ·¨×ª»¯ÎªIntegerÀàÐÍ
ΪÁ˼æÈÝÁ½ÕßÐ޸ĺóµÄ´úÂëΪ£º
  Object o = rs1.getObject(1);
 &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ