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

oracleÊÓÆµ½Ì³Ì£¨ÄÚ²¿¾­µä£©_½² ʦ£ºÍõÖιú


ÏÂÔØµØÖ·£º
http://www.itsoba.com/Article.asp?id=847
ÊÓÆµ½éÉÜ£º
±¾Ì×ORACLEÊÓÆµ½Ì³ÌΪ´«ÖDz¥¿ÍÄÚ²¿¾­µä½ÌѧÊÓÆµµÄÒ»¼¯£¬ºóÐøÊÓÆµÕýÔÚÂ¼ÖÆºÍÕûÀíÖУ¬¾´Çë¹Ø×¢¡£  
½²Ê¦½éÉÜ£º
ÍõÖιú£¬ÓжàÄêÈí¼þ¿ª·¢¾­ÑéºÍ½Ìѧ¾­Ñ飬ÏȺóÔÚ¶à¼ÒÈí¼þ¹«Ë¾µ£ÈÎÈí¼þ¹¤³Ìʦ¡¢ÏîÄ¿¾­Àí£¬¾«Í¨J2SE¡¢J2ME¡¢J2EE¡¢Linux¡¢Oracle¡¢SqlServerµÈ¡£Éó¤´óÐ͵ç×ÓÉÌÎñÍøÕ¾ºÍµç×ÓÕþÎñµÄÉè¼ÆÓ뿪·¢£¬LinuxÏ´óÐÍÓ¦ÓÃÈí¼þµÄ¿ª·¢ÒÔ¼°Ò칹ϵͳÕûºÏµÈ¡£ÏȺó²ÎÓëµÄÏîÄ¿ÓУºÖ¤È¯ÔÚÏß½»Ò×ϵͳ£¬»ùÓÚjavaµÄÒ½ÁƱ£½¡ÏµÍ³£¬SP¶ÌÐÅ¡¢²ÊÁåÔöÖµ·þÎñµÄÉè¼ÆÓ뿪·¢£¬·¢¸ÄίÄÚ²¿°ì¹«ÏµÍ³£¬ÊÖ»úÓÎÏ·µÄ¿ª·¢ÓëÒÆÖ²²¢³É¹¦½â¾ö¸Û°ÄϵͳÊý¾Ý´«ÊäÎÊÌ⣬²ÎÓëÒøÁªÔÚÏß½»Ò×ϵͳµÄ¿ª·¢µÈµÈ¡£ÔøÔÚÈ«¹ú¶àËù³ÇÊУ¨¼ÃÄÏ£¬Ê¯¼Òׯ£¬±±¾©£¬ÉòÑô£¬³¤´º£¬¹þ¶û±õ£©Ñ²½² J2EE¡¢Oracle¡¢LinuxµÈÏà¹Ø¿Î³Ì¡£
ÊÓÆµÄ¿Â¼£º
01
ϵͳȨÏÞ¹ÜÀí
02
¶ÔÏóȨÏÞ
03
ȨÏÞ´«µÝ
04
½ÇÉ«¹ÜÀí
05
ÈýÖֵǽÑéÖ¤»úÖÆ
06
ÕÊ»§¹ÜÀíϸ½Ú
¸ü¶àORACLEÊÓÆµ»á²»¶ÏÍÆ³ö£¡£¡£¡£¡£¡£¡


Ïà¹ØÎĵµ£º

oracle dbaÓ¦¸Ã¶¨ÆÚ×öʲô£¡

ÔØ×ÔoracleÖÐÎļ¼ÊõÂÛ̳¡£´ÓÕûÌåÉϽéÉÜÁËÒ»¸ödbaµÄÖ°ÔðºÍÈÎÎñµÈµÈ¡£¡¡¡¡
ORACLEÊý¾Ý¿â¹ÜÀíÔ±Ó¦°´ÈçÏ·½Ê½¶ÔORACLEÊý¾Ý¿âϵͳ×ö¶¨ÆÚ¼à¿Ø£º 
(1). ÿÌì¶ÔORACLEÊý¾Ý¿âµÄÔËÐÐ״̬,ÈÕÖ¾Îļþ,±¸·ÝÇé¿ö,Êý¾Ý 
¿âµÄ¿Õ¼äʹÓÃÇé¿ö,ϵͳ×ÊÔ´µÄʹÓÃÇé¿ö½øÐмì²é,·¢ÏÖ²¢½â¾ö 
ÎÊÌâ¡£ 
(2). ÿÖܶÔÊý¾Ý¿â¶ ......

oracle ÐòÑÔ

¹ØÓÚдÐò£¬È˵ÄÒ»±²×ÓÓкܶàµÄµÚÒ»´Î£¬¸øÊéдÐò£¬¶ÔÎÒÀ´ËµÒ²ÊǵÚÒ»´Î£¬¶øÇÒÊǺÜÄѵõÚÒ»´Î¡£Ò»°ãÈËÊéдÍêÁË£¬¶¼»áÕÒÒ»¸öÓеãÃûÆøµÄÈËÀ´ÎªÖ®×öÐò£¬ÔÚÕâÀïÎÒÖ»ÄܲÑÀ¢Ò»ÏÂ
¡£ÒòΪÎÒ×ܾõµÃ¸øÒ»±¾ÊéдÐòµÄÈË£¬ÔÚÊéµÄÄÚÈÝ·½Ã棬ÖÁÉÙÒ²µÃÊǰë¸öר¼Ò£¬È»ºó²ÅÄÜÓз¢ÑÔȨ¡£¶ø±¾ÈËÔÚoracle·½Ã棬Á¬°ëͰˮµÄËã²»ÉÏ¡£ÕâÒ»´ÎÒ²¿ÖÅÂÖ»ÄÜÊÇ ......

JavaÁ¬½ÓOracleÎÊÌâ

JavaÖ´ÐÐstm.executeQuery(sql); ʱ×ÜÊÇÌáʾ£ºjava.sql.SQLException: ORA-00911: ÎÞЧ×Ö·û£¬ÅªÁ˰ëÌ컹Êdzö´í£¬ÎÞÄΣ¬ÄóöɱÊÖïµ£¬Googleһϣ¬Ôε¹£¬·¢ÏÖÎÒµÄString  sql = “select detail from test.result where person_id = 4; "£¬Ã²ËÆÃ»´íÎó°É£¬½á¹ûÎÒÎÒ±ØÐëÈ¥µô×îºó·ÖºÅ£¬±¾À´ÊÇÏë¸ãµÃרҵµã£¬¾Í¼Û¼Ó¸ö·Ö ......

oracle·ÖÒ³

racle·ÖÒ³²éѯÓï¾ä
ĬÈÏ·ÖÀà   2009-12-23 18:17   ÔĶÁ43   ÆÀÂÛ0   ×ֺţº ´ó´ó  ÖÐÖР СС Oracle·ÖÒ³²éѯÓï¾ä
±¾ÎÄ×ªÔØ×Ô£ºyangtingkun.itpub.net/post/468/100278
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
sql ´úÂë ......

ORACLEÊý¾Ýµ¼Èë

ÔÚÀûÓÃNETWORK_LINK·½Ê½µ¼³öµÄʱºò£¬³öÏÖÁËÕâ¸ö´íÎó¡£
Ïêϸ´íÎóÐÅÏ¢ÈçÏ£º
bash-3.00$ expdp yangtk/yangtk directory=d_temp dumpfile=jiangsu.dp network_link=test113 logfile=jiangsu.log tables=cat_org
Export: Release11.1.0.6.0 - 64bit Production onÐÇÆÚ¶þ, 16 9ÔÂ, 2008 17:08:22
Copyright (c) 2003, 2007, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ