Oracle 10g ¤«¤é Sqlserver 2005¤ØÊÑ´¹
- ¤³¤Î¥Õ¥©¡¼¥é¥à¤Ë¿·¤·¤¤¥È¥Ô¥Ã¥¯¤òΩ¤Æ¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó
- ¤³¤Î¥Õ¥©¡¼¥é¥à¤Ç¤Ï¥²¥¹¥ÈÅê¹Æ¤¬¶Ø»ß¤µ¤ì¤Æ¤¤¤Þ¤¹
yh-hasegawa
Åê¹Æ¿ô: 32
¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£
³«È¯¥Ð¡¼¥¸¥ç¥ó¤ÏMagic V10¤Ç¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÏOracle 10g¤ò»È¤¤³«È¯¤ò¤·¤Æ¤¤¤Þ¤¹¡£Oracle 10g¤«¤é¡¢Sqlserver 2005¤Ø¥·¥¹¥Æ¥à¤òÊÑ´¹¤·¤¿¤¤¤È¹Í¤¨¤Æ¤¤¤Þ¤¹¡£Â¶¤Î¤È¤¤Ë¹Í¤¨¤é¤ì¤ë¡¢ÌäÂê»ö¹à¤¬¤¢¤ì¤Ð¡¢¶µ¤¨¤Æ¤¤¤¿¤À¤¤¿¤¤¤Î¤Ç¤¹¤¬¡¢µ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Î㡧¡¹àÌܤη¿
¡¡¡¡¢¥¤¥ó¥Ç¥Ã¥¯¥¡¼
¡¡¡¡£¥×¥í¥°¥é¥à¤Ç¤ÎTransaction¤Î°ã¤¤¤Ê¤É
°Ê¾å
µ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
³«È¯¥Ð¡¼¥¸¥ç¥ó¤ÏMagic V10¤Ç¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÏOracle 10g¤ò»È¤¤³«È¯¤ò¤·¤Æ¤¤¤Þ¤¹¡£Oracle 10g¤«¤é¡¢Sqlserver 2005¤Ø¥·¥¹¥Æ¥à¤òÊÑ´¹¤·¤¿¤¤¤È¹Í¤¨¤Æ¤¤¤Þ¤¹¡£Â¶¤Î¤È¤¤Ë¹Í¤¨¤é¤ì¤ë¡¢ÌäÂê»ö¹à¤¬¤¢¤ì¤Ð¡¢¶µ¤¨¤Æ¤¤¤¿¤À¤¤¿¤¤¤Î¤Ç¤¹¤¬¡¢µ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Î㡧¡¹àÌܤη¿
¡¡¡¡¢¥¤¥ó¥Ç¥Ã¥¯¥¡¼
¡¡¡¡£¥×¥í¥°¥é¥à¤Ç¤ÎTransaction¤Î°ã¤¤¤Ê¤É
°Ê¾å
µ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
nobukoshi802
Åê¹Æ¿ô: 118
¡¹àÌܤη¿
¡¡Ê¸»ú¤ÏÂç¾æÉפǤ¹¤¬
¡¡¿ô»ú¤Ï¥ª¥é¥¯¥ë¤Ç¤Ï number MS-SQ¤Ç¤Ï decimal¤ËÊÑ´¹
¢¥¤¥ó¥Ç¥Ã¥¯¥¹¥¡¼
¡¡MS-SQL¤Ç¤Ï¡¢¥×¥é¥¤¥Þ¥ê¡¼¥¡¼¤¬É¬¿Ü¤Ç¤¹¡£
¡¡¥ª¥é¥¯¥ë¤Î¾ì¹ç¡¢rowid¤Ç¥Î¥ó¥æ¥Ë¡¼¥¯¤Ï£Ï£Ë¤À¤Ã¤¿¤Î¤Ç¤¹¡£
£¥×¥í¥°¥é¥à¤Ç¤ÎTransaction¤Î°ã¤¤¤Ê¤É
¡¡°ã¤¤¤Ê¤·
¤MS-SQL¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀßÄê
¡¡¡¦Â°À¤Ëread committed¤Ë¤¹¤ë
¡¡¡¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îʸ»ú¤ò¡¢JapanesseBIN2¤Ë¤¹¤ë
¡¡Ê¸»ú¤ÏÂç¾æÉפǤ¹¤¬
¡¡¿ô»ú¤Ï¥ª¥é¥¯¥ë¤Ç¤Ï number MS-SQ¤Ç¤Ï decimal¤ËÊÑ´¹
¢¥¤¥ó¥Ç¥Ã¥¯¥¹¥¡¼
¡¡MS-SQL¤Ç¤Ï¡¢¥×¥é¥¤¥Þ¥ê¡¼¥¡¼¤¬É¬¿Ü¤Ç¤¹¡£
¡¡¥ª¥é¥¯¥ë¤Î¾ì¹ç¡¢rowid¤Ç¥Î¥ó¥æ¥Ë¡¼¥¯¤Ï£Ï£Ë¤À¤Ã¤¿¤Î¤Ç¤¹¡£
£¥×¥í¥°¥é¥à¤Ç¤ÎTransaction¤Î°ã¤¤¤Ê¤É
¡¡°ã¤¤¤Ê¤·
¤MS-SQL¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀßÄê
¡¡¡¦Â°À¤Ëread committed¤Ë¤¹¤ë
¡¡¡¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îʸ»ú¤ò¡¢JapanesseBIN2¤Ë¤¹¤ë
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: Oracle 10g ¤«¤é Sqlserver 2005¤ØÊÑ´¹
msg# 1.1.1
pu_mahalo
µï½»ÃÏ: Âçºå
Åê¹Æ¿ô: 775
¤³¤ó¤Ë¤Á¤Ï¡¡£Ð£õ¤Ç¤¹
¼ÁÌä¤Î²óÅú¤Ë¼ÁÌä¤Ç¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬
>¤MS-SQL¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀßÄê
>¡¡¡¦Â°À¤Ëread committed¤Ë¤¹¤ë
>¡¡¡¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îʸ»ú¤ò¡¢JapanesseBIN2¤Ë¤¹¤ë
¢¬¤Ï¤É¤¦¤¤¤Ã¤¿Íýͳ¤«¤é¤Ç¤·¤ç¤¦¤«
¼ÁÌ䤷¤Æ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó
¤Ç¤ï¡Á¤Ç¤ï¡Á
¼ÁÌä¤Î²óÅú¤Ë¼ÁÌä¤Ç¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬
>¤MS-SQL¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀßÄê
>¡¡¡¦Â°À¤Ëread committed¤Ë¤¹¤ë
>¡¡¡¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îʸ»ú¤ò¡¢JapanesseBIN2¤Ë¤¹¤ë
¢¬¤Ï¤É¤¦¤¤¤Ã¤¿Íýͳ¤«¤é¤Ç¤·¤ç¤¦¤«
¼ÁÌ䤷¤Æ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó
¤Ç¤ï¡Á¤Ç¤ï¡Á
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
nobukoshi802
Åê¹Æ¿ô: 118
¤¹¤ß¤Þ¤»¤ó¡¢read commited¤ÎÊý¤Ï
¥Ç¡¼¥¿¥Ù¡¼¥¹ÆÃÀ¤ËSQL_PHYSICAL_LOCKING=Y¤òÀßÄê¤Ë¤¹¤ë¤Ç¤·¤¿¡£
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îʸ»ú¡¢JapaneseBIN2¤Ï¡¢»²¾È½ç°Ì¤Ç¤¹
¡Ê´Á»ú¤Îɽ¼¨½çÈÖ¤¬Á°¤È°ã¤¦¤Ã¤Æ¸À¤ï¤ì¤Æ¤·¤Þ¤¦¤«¤é¤Ç¤¹¡Ë
¥Ç¡¼¥¿¥Ù¡¼¥¹ÆÃÀ¤ËSQL_PHYSICAL_LOCKING=Y¤òÀßÄê¤Ë¤¹¤ë¤Ç¤·¤¿¡£
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îʸ»ú¡¢JapaneseBIN2¤Ï¡¢»²¾È½ç°Ì¤Ç¤¹
¡Ê´Á»ú¤Îɽ¼¨½çÈÖ¤¬Á°¤È°ã¤¦¤Ã¤Æ¸À¤ï¤ì¤Æ¤·¤Þ¤¦¤«¤é¤Ç¤¹¡Ë
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: Oracle 10g ¤«¤é Sqlserver 2005¤ØÊÑ´¹
msg# 1.2.1
pu_mahalo
µï½»ÃÏ: Âçºå
Åê¹Æ¿ô: 775
¤³¤ó¤Ë¤Á¤Ï¡¡£Ð£õ¤Ç¤¹
»ä¤¬µ¿Ìä¤Ë»×¤Ã¤¿»ö¤Ç¤¹
Oracle==>SQLserver¡¡¤À¤«¤é¤È¸À¤Ã¤Æ
ʬΥ¥ì¥Ù¥ë¤¬¤³¤ì¤Ç
»²¾È½ç°Ì¤¬¤³¤ì¤Ã¤Æ¡¡°ì³µ¤Ë·è¤á¤ì¤Ê¤¤¤Î¤Ç¤Ï¤Ê¤¤¤«¤È
»×¤Ã¤¿¤«¤é¡¡¼ÁÌ䤵¤»¤Æ¤¤¤¿¤À¤¤Þ¤·¤¿
¡ÊÁÐÊýÀßÄê¤Ç¤¤ë¤«¤é¡Ë
ʬΥ¥ì¥Ù¥ë¤ä»²¾È½ç½ø¤Ï¡¡MAGIC¤Î³«È¯¤È¤Ï´Ø·¸¤Ê¤¤¤È¤³¤í¤Ç
¼ÂºÝ£Ä£Â¤Î¥¤¥ó¥¹¥¿¥ó¥¹¤ä£Ä£Â¤òCREATE¤¹¤ë»þ¤Ë
ɬÍפˤʤäƤ¯¤ë¤«¤È»×¤Ã¤Æ¤Þ¤¹
¤Ç¤¹¤Î¤Ç¡¡Oracle¤ÇÀßÄꤵ¤ì¤Æ¤¤¤ëRDB¤ÎÀßÄêÆâÍƤò¸µ¤Ë
ʬΥ¥ì¥Ù¥ë¤È»²¾È½ç½ø¤òÀßÄꤹ¤ë¤â¤Î¤À¤È»×¤Ã¤Æ¤Þ¤¹
PervasiveE¤«¤é¤Î°Ü¹Ô¤Ç¤·¤¿¤é¡¡¤¢¤ëÄøÅÙ·è¤Þ¤ê¤Þ¤¹¤¬
(Pervasive¤Ë¤ÏÀßÄê¤Ç¤¤Ê¤¤¤«¤é)
»ä¤¬µ¿Ìä¤Ë»×¤Ã¤¿»ö¤Ç¤¹
Oracle==>SQLserver¡¡¤À¤«¤é¤È¸À¤Ã¤Æ
ʬΥ¥ì¥Ù¥ë¤¬¤³¤ì¤Ç
»²¾È½ç°Ì¤¬¤³¤ì¤Ã¤Æ¡¡°ì³µ¤Ë·è¤á¤ì¤Ê¤¤¤Î¤Ç¤Ï¤Ê¤¤¤«¤È
»×¤Ã¤¿¤«¤é¡¡¼ÁÌ䤵¤»¤Æ¤¤¤¿¤À¤¤Þ¤·¤¿
¡ÊÁÐÊýÀßÄê¤Ç¤¤ë¤«¤é¡Ë
ʬΥ¥ì¥Ù¥ë¤ä»²¾È½ç½ø¤Ï¡¡MAGIC¤Î³«È¯¤È¤Ï´Ø·¸¤Ê¤¤¤È¤³¤í¤Ç
¼ÂºÝ£Ä£Â¤Î¥¤¥ó¥¹¥¿¥ó¥¹¤ä£Ä£Â¤òCREATE¤¹¤ë»þ¤Ë
ɬÍפˤʤäƤ¯¤ë¤«¤È»×¤Ã¤Æ¤Þ¤¹
¤Ç¤¹¤Î¤Ç¡¡Oracle¤ÇÀßÄꤵ¤ì¤Æ¤¤¤ëRDB¤ÎÀßÄêÆâÍƤò¸µ¤Ë
ʬΥ¥ì¥Ù¥ë¤È»²¾È½ç½ø¤òÀßÄꤹ¤ë¤â¤Î¤À¤È»×¤Ã¤Æ¤Þ¤¹
PervasiveE¤«¤é¤Î°Ü¹Ô¤Ç¤·¤¿¤é¡¡¤¢¤ëÄøÅÙ·è¤Þ¤ê¤Þ¤¹¤¬
(Pervasive¤Ë¤ÏÀßÄê¤Ç¤¤Ê¤¤¤«¤é)
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
nobukoshi802
Åê¹Æ¿ô: 118
>Oracle¤ÇÀßÄꤵ¤ì¤Æ¤¤¤ëRDB¤ÎÀßÄêÆâÍƤò¸µ¤Ë
>ʬΥ¥ì¥Ù¥ë¤È»²¾È½ç½ø¤òÀßÄꤹ¤ë¤â¤Î¤À¤È»×¤Ã¤Æ¤Þ¤¹
¤½¤ÎÄ̤ê¤Ç¤¹¤Í¡¢¹Íθ¤¬Â¤ê¤Ê¤«¤Ã¤¿¤Ç¤¹¡£
¤½¤ì¤È¡¢¥Æ¡¼¥Ö¥ë¼½ñ¤Î¥ª¡¼¥Ê¡¼Ì¾¤Ëdbo¤òÌÀ¼¨Åª¤Ë
ÀßÄꤹ¤ë¡£
¡ÊWindowsǧ¾Ú¤ò»ÈÍѤ·¤Ê¤¤¤È»×¤¤¤Þ¤¹¤¬¡Ë
>ʬΥ¥ì¥Ù¥ë¤È»²¾È½ç½ø¤òÀßÄꤹ¤ë¤â¤Î¤À¤È»×¤Ã¤Æ¤Þ¤¹
¤½¤ÎÄ̤ê¤Ç¤¹¤Í¡¢¹Íθ¤¬Â¤ê¤Ê¤«¤Ã¤¿¤Ç¤¹¡£
¤½¤ì¤È¡¢¥Æ¡¼¥Ö¥ë¼½ñ¤Î¥ª¡¼¥Ê¡¼Ì¾¤Ëdbo¤òÌÀ¼¨Åª¤Ë
ÀßÄꤹ¤ë¡£
¡ÊWindowsǧ¾Ú¤ò»ÈÍѤ·¤Ê¤¤¤È»×¤¤¤Þ¤¹¤¬¡Ë
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: Re: Oracle 10g ¤«¤é Sqlserver 2005¤ØÊÑ´¹
msg# 1.3.1
Tanda
Åê¹Æ¿ô: 2151
nobukoshi802 ¤µ¤ó¡¢¤³¤ó¤Ë¤Á¤Ï¡£
¥ª¡¼¥Ê¡¼Ì¾¤Î dbo ¤â¼«Æ°Åª¤ËÀßÄꤵ¤ì¤ë¤Ï¤º¤Ç¤¹¤è¡£(^^)
¥¿¥ó¥À¥³¥ó¥Ô¥å¡¼¥¿¡¿Ã°ÅÄ ¾»¿®
¥ª¡¼¥Ê¡¼Ì¾¤Î dbo ¤â¼«Æ°Åª¤ËÀßÄꤵ¤ì¤ë¤Ï¤º¤Ç¤¹¤è¡£(^^)
¥¿¥ó¥À¥³¥ó¥Ô¥å¡¼¥¿¡¿Ã°ÅÄ ¾»¿®
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00