´ÓÒ»¸öORACLEÊý¾Ý¿âÓÃÃüÁîEXP DUMMY/DUMMY FILE=D£º\ORAB.DMP LOG=d:\ORAB.LOG FULL=Yµ¼³öÁ½¸öÎļþ£¬ÔÚÁíÍâÒ»¸ö»úÆ÷ÉÏ×°ÁËÒ»¸öORACLE 10GR2µÄϵͳ£¬Á½Ì¨»ú°æ±¾Ò»ÑùµÄ£¬ÔÚÕą̂ÉÏÓÃÃüÁî IMP SYSTEM/SYSTEM FILE=H:\ORAB.DMP LOG=H:\ORAB.LOG FULL=Y£¬¿Éµ¼Èë³öÏÖÁË´íÎó£¬ÏÔʾ£ºALTER SESSION ZKE¡£¡£¡£ZKEÓû§²»´æÔÚ¡£
ÎÊÌâ ......
a)select * from member t where upper(t.nickname)=upper('Óû§Ãû)
b)select * from member t where t.nickname='Óû§Ãû'
4ÒÚÊý¾ÝÁ¿µÄÇé¿öÏ£¬aÓï¾ä²éѯËٶȱÈbÓï¾ä¿ìºÜ¶à,bÓï¾äÖ±½Ó²éѯËÀµô£¬aÓï¾ä²éѯ½á¹ûËٶȼ«¿ì£¬ÇëÎÊΪʲô£¿
²»ÖªµÀ,°ï¶¥.
ÎÒ»¹ÒÔΪB±ÈA¿ìÄØ.
Ï벻ͨ°¡¡£¡£Ïë²» ......
ÎÒÏ뽨һ¸öºó׺ÃûΪvbsµÄÎļþ£¬µ±µãÔËÐиÃÎļþÊÇÄÜÖ´ÐÐÏÂÃæµÄsqlÓï¾ä:
select name from accts where acct="100001"
²¢ÄÜÏÔʾ³öÖ´Ðнá¹û(ÓÃmsgbox).
Êý¾Ý¿âΪOracleÊý¾Ý¿â,Êý¾Ý¿âÃû£ºmydatabase,Óû§Ãû:myuserid,ÃÜÂë:mypassword.
ÔõÑùʵÏÖ£¿ÇëÖ¸µ¼Ò»Ï¡£×îºÃ¸ø³ö´úÂ룬лл£¡
createobject
ÆäËû ......
֮ǰµÄxpϵͳ ×°ÁËoracle 9iR2 µ«ÒòΪϵͳ »µÁË£¬ÖØÐÂ×°Á˸öxp
ÏÖÔÚҪװoracle 9iR2 È´ÏÖÁ˱êÌâΪjavaw.exeͼÏñË𻵠ÄÚÈÝÊÇoraInstall2009-12-30-10-18-40AM\jre\bin\jpeg.dllΪÎÞЧµÄwindows Ó³ÏñµÄ´°¿Ú(¶Ô»°´°¿Ú)
ÔÚgoogle ÀïËÑË÷¹ý
˵ÊǰÑÖ÷Ìâ»»³Éxp
oralce ûɾ³ý¸É¾»
ÎÒ°Ñ ......
C# code:
/// <summary>
/// ·ÖÒ³
/// </summary>
/// <param name="PageSize"></param>
/// <param name="CurrentPage"></param>
/// <param name="poolid"></param>
/// ......
ÈçºÎ¶¨ÒåÒ»¸öJOBÈÃËüÔÚÿÌìµÄ8:30 13:30 17:00 ÕâÈý¸öʱ¼ä¶ÎÔËÐÐÒ»¸ö¹ý³Ì£¿
лл¡£
Ìá½»Èý¸öJOB¾ÍÐУ¬Ö´ÐеĴúÂëÏàͬ¡£
ºÇºÇÊÇÒ»¸ö½â¾ö·½·¨£¬²»¹ýjob¶àÁË¡£ÎÒÉÏÃæËµµÄÈý¸öʱ¼äµã
ÓÐʱÎÒµÄÊǸöʱ¼ä±í£¬°´Ò»¶¨µÄʱ¼äÖ´ÐУ¬¿ÉÄÜÊÇ20¸öʱ¼äµãÌ«Âé·³ÁË
ÄÇÖ»ÄÜÿСʱִÐÐÒ»´Î£¬ÔÚ¹ý³ÌÖÐÅжÏһϵ±Ç°Ê ......