oracleɾ³ý±íÖÐËùÓеÄÊý¾Ý
ʾÀýÒ»£ºdelete from emp;
ʵÀý¶þ£ºtruncate table emp;
µ±Ê¹ÓÃdeleteɾ³ýʱ£¬ËäȻɾ³ýÁ˱íÖеÄËùÓÐÊý¾Ý£¬µ«ÊÇûÓÐÊͷűíËùÕ¼µÄ¿Õ¼ä£¬Èç¹ûÓû§È·¶¨ÒªÉ¾³ý±íÖÐËùÓÐÊý¾Ý£¬Ê¹ÓÃʵÀý¶þÓï¾äËٶȸü¿ì¡£deleteÓï¾ä¿ÉÒÔ»ØÍË£¬µ«truncateÓï¾ä²Ù×÷²»ÄÜ»ØÍË£¬Ö´ÐеÄʱºòÒª¶à¼Ó×¢ÒâÕâÒ»µã¡£
Ïà¹ØÎĵµ£º
»ù±¾ÒªÇó
win 7µÄ°æ±¾ÊÇÆì½¢°æ£¬oracle 10g£¨Oracle10gµÚ2°æ10.2.0.3-10.2.0.410203vistaw2k8x86productiondb£©Ñ¸À×ÓÐÏÂÔØ
£¨ËÑË÷“oracle 10g vista”£¬760MB£©
¾ßÌå¹ý³Ì
1.ÅäÖÃÒ»¸öÐéÄâµÄIP£ºÔÚ°²×°ORACLE 10gǰϵͳ»á¼ì²â°²×°µÄһЩǰÌáÌõ¼þÊÇ·ñÂú×㣬
ÍùÍù»áÌáʾ˵£º½«Microsoft LoopBack AdapterÅäÖÃΪ ......
Ô·¢±íÓÚhttp://saharabear.javaeye.com
ͬʱ·¢±íÔÚÕâÀï.
²»ÐèÒªÏàÐÅÉÌÒµÉϵÄÈκγÐŵ,²»¹ýÈκεĹٷ½FAQ¶¼»áÓвο¼¼ÛÖµ,ÕâÀï
ÊÇOracle·¢²¼µÄÕë¶ÔSunµÄ¸÷Ïî²úÆ·µÄһЩ˵Ã÷µÄFAQ,»ù±¾ÉÏÃèÊöÁ˶ÔGlassfish¼ÌÐøÖ§³Ö,¶ÔNetbeans¼ÌÐø¿ª·¢µÄ̬¶È,²»¹ý,kenai.com,ΰ´óµÄ"ÎÒÃDz»½ö½öÊÇ´úÂëÍйÜ"µÄÉç½»ÐÔ¿ª·¢Õ¾µã,»ù± ......
1¡¢´æ´¢¹ý³ÌºÍº¯ÊýµÄÇø±ð¡£
£¨1£©¡¢´æ´¢¹ý³ÌÊÇ×÷ΪPL/SQLÓï¾äÖ´ÐУ¬¶øº¯ÊýÊÇ×÷Ϊ±í´ïʽµÄÒ»²¿·Öµ÷Óã»
£¨2£©¡¢´æ´¢¹ý³ÌÔÚ¹æ¸ñ˵Ã÷Öв»°üº¬returnÓï¾ä£¬¶øÔÚº¯ÊýµÄ¹æ¸ñ˵Ã÷Õâ°üº¬return×Ӿ䣻
(3)¡¢´æ´¢¹ý³Ì²»·µ»ØÖµ£¬¶øº¯Êý±ØÐë·µ»ØÖµ£»
£¨4£©¡¢ÔÚ´æ´¢¹ý³ÌÖпÉÒÔ°üº¬returnÓï¾ä£¬µ«²»·µ»ØÈκÎÖ ......
ת×Ô£ºhttp://download.oracle.com/docs/cd/B13789_01/server.101/b10759/statements_6004.htm
Creating User-Defined Operators: Example
This example creates a very simple functional implementation of equality and then creates an operator that uses the function:
CREATE FUNCTION eq_f(a VARCHAR2, b VARCHA ......
¸ù¾ÝÓû§µ¼³öÓï¾ä£º
1.Êý¾Ý¿âµ¼³ö
exp system/jade@JADE_166.111.134.26 file=d:\jade.dmp statistics=none
˵Ã÷£º
systeÊÇÓû§Ãû
jadeÊÇÃÜÂë
JADE_166.111.134.26ÊÇSID±êʾ
file=d:\jade.dmp Êǵ¼³öÎļþµÄ·¾¶¼°ÎļþÃû
2.Êý¾Ý¿âµ¼Èë
imp system/jade@JADE_166.111.134.26 file=d:\jade.dmp fromuser=syst ......