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

ORACLE,ÎÒÀ´ÁË£¡

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

hehe

½Ó·Ö£¬ding

OK !
jf



»¶Ó­...

»¶Ó­»¶Ó­~



²äµã·Ö¡£

ǰʮ»¶Ó­

ͬ¥ÉÏ

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

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

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


»¶Ó­

ÎÅ·Ö¶ø¶¯

ÒÔºóÏ£Íû¸÷λ¶à¶àÖ¸½Ì£¡

ËäÈ»×öÁ˼¸Ä꿪·¢£¬µ«ÊÇORACLE ¾ø¶ÔÊdzõѧÕß

ÎÒÒ²ÊǸտªÊ¼½Ó´¥£¬Ò»Æðѧϰ£¡

ºÍ

½Ó·Ö°¡

¶à¶à¹ØÕÕ£¡~

ÎÒ±ÈÄãÔçÀ´µã

day day up~~

¶¥Äã

ÒýÓÃ
¶à¶à¹ØÕÕ£¡~

en

½Ó·Ö¡£

»¹ÊÇѧoracle±È½ÏºÃЩ£¬¿ÉÊÇÏë´î½¨¸öºÃ»·¾³²»Ò×°¡¡£

»¶Ó­³£À´``

¹²Í¬Ñ§Ï°

Ö§³Ö

Â¥Ö÷ÊǸöSQL server¸ßÊÖ¡£ »¶Ó­¡£

ÔÚÕâÀï¼ûµ½ÀäÐÖ£¨ks_reny£©£¬¿ªÐÄ£¡

ÒÔºóÖ÷Òª¶¼ÔÚORACLEÀï»ìÁË¡£
Ò²Çë¶à¶àÖ¸½Ì£¡

²»Öª»¹ÓзÖô  »¶Ó­

Â¥Éϵģ¬Óзֵġ£

¼ûÕßÓз֡£

˳±ãÎÊÏ£º
Ŀǰ´ó¼ÒÓõͼÊÇÄǸö°æ±¾¡£

֮ǰÁ˽â¹ýһЩºÃÏñÊÇ9i£¬ÏÖÔÚºÃÏñ11g¶¼ÓÐÁË¡£

ÊÖÍ·Óб¾ORACLE 10g¿ª·¢Ö¸ÄÏ¡£


»¶Ó­~~~~~

½Ó·Ö

ÿ¸öа汾¶¼ÓÐÐÂÌØÐÔ£¬¸ú×Ű汾×ßÌ«ÀÛÁË£¬ÎÒ»¹ÊÇÏÈ


Ïà¹ØÎÊ´ð£º

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

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

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

ÀÏÎÊÌ⣺OracleÐÐתÁУ¨×Ö·û´®²ð·Ö£©

ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ