×öORACLEÊý¾Ý¿â¹ÜÀí£¬¶ÔLINUXµÄÒªÊìϤµ½Ê²Ã´³Ì¶È
¾³£»á¿´µ½LINUXµÄ±à³Ì£ºÈçʲôSHELL±à³Ì£¬Ê²Ã´Äں˱à³Ì°¡
×öORACLEÒªÁ˽âÕâЩÂð?
´ó¼ÒÒ»ÆðÌÖÂÛÌÖÂÛ¡£
ÊìϤ»ù±¾²Ù×÷¾Í¿ÉÒÔÁË£¬µ«ÖÁÉÙÒªÄÜÔÚLinuxÉϰ²×°Oracle...
ÓÐÒ»µãshell »ù´¡µÄ»°¸üºÃ£¬ÒòΪһЩ½Å±¾¾ÍÊÇÓÃshellдµÄ¡£
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Äê¸ø 2 ת³ö 1 ±Ê 500Ôª
2009 1 3 1 100 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
[size=11px]Error while performing database login with the op driver;
Io exception:Message file 'oracle.net.mesg.message' is missing[/size]
Çë¸÷λ¸ßÊÖÖ¸µã£¬ÉÏÊö´íÎóÓ¦ÈçºÎ¸üÕý£¬3Q£¡£¡£¡
ÎÊÌâµãÊý:2·Ö???
ÒýÓÃ
ÎÊÌâµãÊý:2·Ö???
Êǹ»ÁߨĵÄ
oracleÇý¶¯×°ÁËû£¿×°µÄ¶Ô² ......
¡¡¡¡VSO5×öÁËÒ»¸öÔöɾ¸ÄµÄ¶«Î÷£¬¹«Ë¾OracleÔËÐеÄûÓÐÎÊÌâ,»Ø¼ÒÓÃACCESSÔËÐо͵ò»µ½½á¹û¡£
¼àÊÓÁËÏÂSQLÓï¾ä£¬Ïò´óϺÇë½ÌÏ£¡
Ò».SQLÓï¾ä²åÈë²âÊÔ
£±¡£Oracle,ACCESS½¨ÁËÒ»¸öͬÑùµÄ±í
£².¡¡¶¼ÓÃÓï¾äinsert into ISSUE_STATUS (ISSUENO,ITHANDLE,ISSUE_STATUS,ITREMARK) values('ddd111','' ......
ÒªÇó£º
1£©½«Ò»Ì¨oracleÖ÷Êý¾Ý¿âµÄÊý¾ÝÖеÄijЩ±íͬ²½¸üе½¶ą̀sqlserver·þÎñÆ÷É϶ÔÓ¦±íÖУ»
2£©×îºÃÄÜʱʵͬ²½£¬Èç¹û²»ÄÜʱʵ£¬¶¨Ê±Í¬²½Ò²¿ÉÒÔ¡£
3£©×îºÃ²»ÒÀÀµ³ÌÐò×öͬ²½¸üУ¬µ¥´¿Í¨¹ýÊý¾Ý¿â×ÔÉíʵÏÖ¡£
Ìõ¼þ£º
oracle9i;sqlserver2000;
Ã²ËÆ²»´ó¿ÉÄÜ
¾Í±»ÅÐËÀÐÌÁË£¿£¿
×ö¸öJOB
ÒýÓÃ ......
±íÃû£º testdate
×Ö¶Î
id Ö÷¼ü varchar2
dtime date
ÏÖÔÚÊǿյģ¬
ÇóÑ»·²åÈë´Ë±íÖе±Ç°ÈÕÆÚµ½Ã÷ÄêµÄ½ñÌì¼Ç¼µÄÓï¾ä
¼´£º
2009-11-27
2009-11-28
2009-11-29
.....
2010-11-26
2010-11-27
SQL code:
declare
dbegindate dat ......