oracle 11g ÔõÃ´ÒÆ¶¯±í¿Õ¼ä£¿ - Oracle / »ù´¡ºÍ¹ÜÀí
Ôõô°Ñһ̨µçÄÔÖеıí¿Õ¼äÒÆ¶¯µ½Áíһ̨ÖÐÓã¿
ORACLE¡¡£±£±£Ç
¾ßÌåµãлл£¬×îºÃÄܾٸöÀý×Ó£¬ÍøÉϵͼÊÇ£¸iµÄ²Ù×÷²½Ö裬²»ÔõôºÃÓÃ
Êý¾Ý°áǨ£¿ Â¥Ö÷»¹ÊÇ˵Çå³þµã°É¡£
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
Êý¾Ý°áǨ Ò²¿ÉÒÔÓÃexp imp
±í¿Õ¼ä ±¾Éí¾ÍÊǸöÂß¼¸ÅÄî
±È·½ËµÓбí¿Õ¼ätest£¬testÀïÓкܶà±í£¬ÎÒÔÚ×Ô¼ºµçÄÔÉ϶ÔÕâЩ±í×öÁ˺ܶà²Ù×÷£¬ÏÖÔÚÎÒÏ£ÍûÔÚÁíÍâµÄµçÄÔÉϼÌÐø²Ù×÷£¬ÔõôŪ£¿
ÄÜÖ±½Ó·ÖÀë·Å£ÕÅÌÉÏ£¬ÔÚÁíÍâµçÄÔÉÏÖ±½ÓÓÃÂ𣿣ϣңÁ£Ã£Ì£ÅÖ§³ÖÈȲå°ÎÂð£¿
2̨PCÖ®¼äÄÜ»¥Ïà·ÃÎÊÂ𣿠Èç¹ûÄÜ×ö¸öDBLINK¾Í¿ÉÒÔÁË¡£
oracle db link
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4698642.aspx
--------------------------------------------------------------
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......