°®ÉÏOracleÁË.......
ÎÒÒÔǰÓÃMS SQL SERVER 2005,½ñÌìÎÒÊÔÁËÒ»ÏÂOracle9I ÎÒÈçÏÂÃæµÄÓï¾ä²âÁËһϠdeclare @II int; set @II=1; while @II <99999 begin insert into student values(3,'ÕÅÈý',89,98); set @II=@II+1; end; Òª30Ãë, ORACLE 9iÖ»ÓÃ17Ãë,ÍÛ...ÕæÊǸö´óÐÍÊý¾Ý¿âѽ..ºÇºÇ.. ÎÒÃÇÔÙ¿´Ò»Ï±íµÄ·ÖÇø...ÍÛ..Ì«·½±ãÁË,,,Oracle´Ó8I¾Í¿ªÊ¼Óбí·ÖÇøÁË... ¿ÉÊÇMS SQL SERVERµ½2008²ÅÐÐ,Ò²²»·½±ã²Ù×÷...°¦..... ´ó¼ÒÔõô¿´? ´ó¼ÒÒ»¶¨ÒªËµ,²âÊÔ²»È«Ãæ¹þ...ÔÚÓ¦ÓÃÖвåÈëºÍ²éѯÊǽ϶àµÄ°É
ßÀ¡£¾ÍÒòΪÕâ¸öÔÒò£¿£¿£¿ ...........ÍÛ,Â¥Ö÷²»ÊÇÔÚ´ò¹ã¸æ°¡!ÕæµÄ°¡!ÒýÓà ...........ÍÛ,Â¥Ö÷²»ÊÇÔÚ´ò¹ã¸æ°¡!ÕæµÄ°¡! Oracle²»ÐèÒªÎÒÀ´´ò¹ã¸æÑ½...ÄãËµÄØ....ÓÃÁ˵ÄÈ·ºÃѽ....ÎÒÏÖÔÚÕýÔÚѧϰ Óиö¸ÐÊÜ....×ß³ö΢ÈíµÄÊÀ½ç,ÍâÃæµÄÊÀ½çºÃ¾«²Êà¸,,,,,,ºÇºÇ.. ÄãÊÔ¹ý ɾµôÒ»¸öû±¸·ÝµÄ·ÖÇø±í È»ºóÕû¸ö·ÖÇøÀïÃæµÄÊý¾Ý¶¼Ã»ÁËÂ𣿠up ¸÷ÓÐÓÅȱµã¡£ ¸÷ÓÐǧÇÈç¹û²î¾à¹ý´ó£¬ÄÇô΢Èí¾ÍÍÚÈËÁË£¬£¬¹þ Äã¿´µ½oracleµÄ²»ºÃÁË£¬¾Í¸ÃÒª²»Ñ§ÁË£¬¼ÌÐøsql ¸÷ÓÐËù³¤°É Ö÷Òª»¹ÊÇ¿´ÐèÇó ¿Ï¶¨¾ÍÊÇOracleÔÚÊý¾ÝÉè¼ÆÉÏ,ºÃ¶à˼ÏëÓ¦¸Ã»¹ÊÇ×ßÔÚSQLÇ°ÃæµÄ Oracle, ²»Ö¹ÊÇÊý¾Ý¿â Êý¾Ý¿â¸÷ÓÐÓÅÊÆ£¬¸ù¾Ý²»Í¬ÐèҪʹÓà sqlÓÐÎļþ×é°¡£¬Äã²»ÖªµÀ¶øÒÑ ***¸øÂ¥Ö÷µÄ½¨Òé*** OracleĬÈÏÊÇ·Ç×Ô¶¯Ìá½»£¬¼´µ±ÄãÖ´ÐÐÄǶδúÂëºó£¬OracleÊÇÌá½»Ò»´Î MSSQLĬÈÏÊÇ×Ô¶¯Ìá½»£¬¼
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i 2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1 3.oracle sql developer°æ±¾ 1.5.5 ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn ×Ô¼º¶¥¡£¡£¡£ ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ! ²»ÖªµÀÓÐûÓÐ ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡. oracle 10g ÓÃps/sql devÔõôҲÁ¬²»ÉÏ. ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË. listener.ora: SID_LIST_LISTENER = (SID_LIST = ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......