oracleʹÓÃ×Ó²éѯ²åÈëºÍÐÞ¸ÄÊý¾Ý
ʹÓÃ×Ó²éѯ²åÈëÊý¾Ý£º
ʾÀýÒ»£ºinsert into employee (empno,ename,sal,deptno)
select empno,ename,sal,deptno from emp
where deptno=20;
ʾÀý¶þ£ºinsert /*+APPEND*/ into employee (empno,ename,sal,deptno)
select empno,ename,sal,deptno from emp
where deptno=20;
¾¡¹ÜÖ´Ðнá¹ûÒ»Ñù£¬µ«µÚ¶þÌõÓï¾äʹÓÃ/*+APPEND*/À´±íʾ²ÉÓÃÖ±½Ó×°ÔØ·½·¨¿ÉÒÔʹִÐÐËٶȼӿ졣
ʹÓÃ×Ó²éѯÐÞ¸ÄÊý¾Ý£º
ʾÀýÒ»£ºselect job,sal,comm from emp where ename='SMITH';
update emp set job='check',sal=2200,comm=200
where ename='SCOTT';
ʾÀý¶þ£ºupdate emp set (job,sal,comm)=(
select job,sal,comm from emp where ename='SMITH')
where ename='SCOTT';
Õâ¸öÀý×Ó˵µÄÊÇ£ºÊ¹¹ÍÔ±SCOTTµÄ¸Úλ¡¢¹¤×Ê¡¢²¹ÖúÓë¹ÍÔ±SMITHµÄÍêÈ«Ïàͬ¡£ÕâʱºòʹÓÃ×Ó²éѯֻÐèÒª±àдһÌõsqlÓï¾ä¾Í¿ÉÒÔÍê³ÉÈÎÎñ£¬´Ó¶ø½µµÍÁËÍøÂ翪Ïú¡£
Ïà¹ØÎĵµ£º
Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......
Ô·¢±íÓÚhttp://saharabear.javaeye.com
ͬʱ·¢±íÔÚÕâÀï.
²»ÐèÒªÏàÐÅÉÌÒµÉϵÄÈκγÐŵ,²»¹ýÈκεĹٷ½FAQ¶¼»áÓвο¼¼ÛÖµ,ÕâÀï
ÊÇOracle·¢²¼µÄÕë¶ÔSunµÄ¸÷Ïî²úÆ·µÄһЩ˵Ã÷µÄFAQ,»ù±¾ÉÏÃèÊöÁ˶ÔGlassfish¼ÌÐøÖ§³Ö,¶ÔNetbeans¼ÌÐø¿ª·¢µÄ̬¶È,²»¹ý,kenai.com,ΰ´óµÄ"ÎÒÃDz»½ö½öÊÇ´úÂëÍйÜ"µÄÉç½»ÐÔ¿ª·¢Õ¾µã,»ù± ......
SQL> select * from ta;
ID NAME
---------- --------------------
1 gorey
2 gorey2
SQL> select * from tb;
I ......
ת×Ô£º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 ......
¡¡Ò»¡¢OracleÊý¾Ý¿âÖ§³ÖµÄ´ó¶ÔÏóÊý¾ÝÀàÐÍ¡£
¡¡¡¡ÔÚOracleÊý¾Ý¿âÖÐΪÁ˸üºÃµÄ¹ÜÀí´óÈÝÁ¿µÄÊý¾Ý£¬×¨ÃÅ¿ª·¢ÁËһЩ¶ÔÓ¦µÄ´ó¶ÔÏóÊý¾ÝÀàÐÍ¡£¾ßÌåµÄÀ´Ëµ£¬ÓÐÈçϼ¸ÖÖ£º
¡¡¡¡Ò»ÊÇBLOBÊý¾ÝÀàÐÍ¡£ËüÊÇÓÃÀ´´æ´¢¿É±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý¡£ÓÉÓÚÆä´æ´¢µÄÊÇͨÓõĶþ½øÖÆÊý¾Ý£¬Îª´ËÔÚÊý¾Ý¿âÖ®¼ä»òÕßÔÚ¿Í»§¶ËÓë·þÎñÆ÷Ö®¼ä½øÐд«ÊäµÄʱºò£¬ ......