Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

¹ØÓÚORACLE 10GµÄÊý¾Ýµ¼ÈëÎÊÌ⣿

´ÓÒ»¸ö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Óû§²»´æÔÚ¡£
ÎÊÌâ ......

OracleÉÏÒÚÊý¾Ý²éѯ£¬Åöµ½Ò»¸öÎÊÌ⣬Çë½Ìϸ÷λDBA

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ÎļþÔõÑùÄÜʵÏÖÁ¬½ÓOracleµÄ¹¦ÄÜ£¿

ÎÒÏ뽨һ¸öºó׺ÃûΪvbsµÄÎļþ£¬µ±µãÔËÐиÃÎļþÊÇÄÜÖ´ÐÐÏÂÃæµÄsqlÓï¾ä:
select name from accts where acct="100001"
²¢ÄÜÏÔʾ³öÖ´Ðнá¹û(ÓÃmsgbox).
Êý¾Ý¿âΪOracleÊý¾Ý¿â,Êý¾Ý¿âÃû£ºmydatabase,Óû§Ãû:myuserid,ÃÜÂë:mypassword.
ÔõÑùʵÏÖ£¿ÇëÖ¸µ¼Ò»Ï¡£×îºÃ¸ø³ö´úÂ룬лл£¡
createobject
ÆäËû ......

oracle 9i R2°²×°ÎÊÌâ

֮ǰµÄxpϵͳ ×°ÁËoracle 9iR2 µ«ÒòΪϵͳ »µÁË£¬ÖØÐÂ×°Á˸öxp

ÏÖÔÚҪװoracle 9iR2 È´ÏÖÁ˱êÌâΪjavaw.exeͼÏñË𻵠 ÄÚÈÝÊÇoraInstall2009-12-30-10-18-40AM\jre\bin\jpeg.dllΪÎÞЧµÄwindows Ó³ÏñµÄ´°¿Ú(¶Ô»°´°¿Ú)

ÔÚgoogle ÀïËÑË÷¹ý

˵ÊǰÑÖ÷Ìâ»»³Éxp
oralce ûɾ³ý¸É¾»


ÎÒ°Ñ ......

¹ØÓÚoracle²éѯ·ÖÒ³µÄÎÊÌâ

C# code:

/// <summary>
/// ·ÖÒ³
/// </summary>
/// <param name="PageSize"></param>
/// <param name="CurrentPage"></param>
/// <param name="poolid"></param>
/// ......

oracle job¶¨Èý¸ö²»Í¬Ê±¼äµãÔËÐС£

ÈçºÎ¶¨ÒåÒ»¸öJOBÈÃËüÔÚÿÌìµÄ8:30  13:30 17:00 ÕâÈý¸öʱ¼ä¶ÎÔËÐÐÒ»¸ö¹ý³Ì£¿

лл¡£
Ìá½»Èý¸öJOB¾ÍÐУ¬Ö´ÐеĴúÂëÏàͬ¡£

ºÇºÇÊÇÒ»¸ö½â¾ö·½·¨£¬²»¹ýjob¶àÁË¡£ÎÒÉÏÃæËµµÄÈý¸öʱ¼äµã

ÓÐʱÎÒµÄÊǸöʱ¼ä±í£¬°´Ò»¶¨µÄʱ¼äÖ´ÐУ¬¿ÉÄÜÊÇ20¸öʱ¼äµãÌ«Âé·³ÁË

ÄÇÖ»ÄÜÿСʱִÐÐÒ»´Î£¬ÔÚ¹ý³ÌÖÐÅжÏһϵ±Ç°Ê ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [150] [151] [152] [153] 154 [155] [156] [157] [158] [159]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ