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

°®ÉÏ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ĬÈÏÊÇ×Ô¶¯Ìá½»£¬¼


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ