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

oracle 11g ÔõÃ´ÒÆ¶¯±í¿Õ¼ä£¿ - Oracle / »ù´¡ºÍ¹ÜÀí

Ôõô°Ñһ̨µçÄÔÖеıí¿Õ¼äÒÆ¶¯µ½Áíһ̨ÖÐÓã¿
ORACLE¡¡£±£±£Ç
¾ßÌåµãлл£¬×îºÃÄܾٸöÀý×Ó£¬ÍøÉϵͼÊÇ£¸iµÄ²Ù×÷²½Ö裬²»ÔõôºÃÓÃ
ÒýÓÃ
Ôõô°Ñһ̨µçÄÔÖеıí¿Õ¼äÒÆ¶¯µ½Áíһ̨ÖÐÓã¿
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ÀïÓкܶà±í£¬ÎÒÔÚ×Ô¼ºµçÄÔÉ϶ÔÕâЩ±í×öÁ˺ܶà²Ù×÷£¬ÏÖÔÚÎÒÏ£ÍûÔÚÁíÍâµÄµçÄÔÉϼÌÐø²Ù×÷£¬ÔõôŪ£¿
ÄÜÖ±½Ó·ÖÀë·Å£ÕÅÌÉÏ£¬ÔÚÁíÍâµçÄÔÉÏÖ±½ÓÓÃÂ𣿣ϣңÁ£Ã£Ì£ÅÖ§³ÖÈȲå°ÎÂð£¿

ÒýÓÃ
±È·½ËµÓбí¿Õ¼ätest£¬testÀïÓкܶà±í£¬ÎÒÔÚ×Ô¼ºµçÄÔÉ϶ÔÕâЩ±í×öÁ˺ܶà²Ù×÷£¬ÏÖÔÚÎÒÏ£ÍûÔÚÁíÍâµÄµçÄÔÉϼÌÐø²Ù×÷£¬ÔõôŪ£¿
ÄÜÖ±½Ó·ÖÀë·Å£ÕÅÌÉÏ£¬ÔÚÁíÍâµçÄÔÉÏÖ±½ÓÓÃÂ𣿣ϣңÁ£Ã£Ì£ÅÖ§³ÖÈȲå°ÎÂð£¿


2̨PCÖ®¼äÄÜ»¥Ïà·ÃÎÊÂ𣿠Èç¹ûÄÜ×ö¸öDBLINK¾Í¿ÉÒÔÁË¡£ 

oracle db link 
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4698642.aspx



--------------------------------------------------------------


Ïà¹ØÎÊ´ð£º

¶à±í¹ØÁª²éѯµÄ sqlд·¨ - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ