ORACLEº¯Êý´óÈ«

LONEFOXÌâ¼Ç£º
×î½ü¸ãORACLE£¬ ת¹ýÀ´¹©²Î¿¼¡£
=================================
1¡¢SQL Óï¾ä»ù´¡
ÏÂÃæ¸ø³öSQLÓï¾äµÄ»ù±¾½éÉÜ¡£
1.1¡¢SQLÓï¾äËùÓ÷ûºÅ
²Ù×÷·û
 ÓÃ;
 Àý×Ó
 
+ -
 ±íʾÕýÊý»ò¸ºÊý£¬ÕýÊý¿ÉÊ¡È¥ +
 -1234.56
 
+
 ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼Ó
 A=c+b
 
-
 ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼õ
 34-12
 
*
 ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà³Ë
 12*34
 
/
 ³ýÒÔÒ»¸öÊý»ò±í´ïʽ
 18*11
 
NULL
 ¿ÕÖµÅжÏ
 Where name is null;
 
||
 ×Ö·û´®Á¬½Ó
 ‘101-’||tel_num
 
=
 µÈÓÚ²âÊÔ
 Select * from emp  where name=’ÕÔÔª½Ü’;
 
!= »ò<>»ò^=
 ²»µÈÓÚ²âÊÔ
 Select * from emp  where name !=’ÕÔÔª½Ü’;
 
<
 
 Ð¡ÓÚ²âÊÔ
 Select * from emp  where sal < 5000;
 
>
 
 ´óÓÚ²âÊÔ
 Select * from emp  where sal > 5000;
 
<=
 Ð¡ÓÚµÈÓÚ²âÊÔ
 Select * from emp  where sal <= 5000;
 
>=
 ´óÓÚµÈÓÚ²âÊÔ
 Select * from emp  where sal >= 5000;
 
Not  in
 ²âÊÔijֵÊÇ·ñÔÚÒ»¸öÖ¸¶¨µÄ½á¹û¼¯ÖÐ
 Select name,addr from expert where local not in(‘±±¾©’,’ÉϺ£’);
 
ANY
 ½«Ò»¸öÖµÓëÒ»×éÖµ½øÐбȽϣ¬·µ»ØÂú×ãÌõ¼þµÄ½á¹û¡£±ØÐë¸ú!=,<,>,<=,>=
 select ename,sal from emp where sal<= any(select sal from emp where deptno=10)
 
SOME
 Í¬ANY£¬±ØÐë¸ú!=,<,>,<=,>=
 
 
 
ALL
 ½«Ò»¸öÖµÓëÒ»×éÖµ±È½Ï£¬·µ»ØÂú×ãÌõ¼þµÄËùÓÐÁÐÖµ¡£±ØÐë¸ú!=,<,>,<=,>=
 Select name,sal from emp w here sal<= all
( 500,800,1200);
 
Not between
A and B
 ÅжÏij¸öÖµÊÇ·ñ½çÓÚÁ½ÕßÖ®¼ä¡£
 Select name,sal from emp Where
sal between  500 and 1200;
 
[not]exists
 ÅжÏij¸öÁÐÊÇ·ñ´æÔÚÓÚÒ»×éÖµÖС£
 select dname,deptno from dept where exists
(select * from emp wher