Oracle»ù±¾

1.desc(ÃèÊö£© emp    ÃèÊöempÕâÕűí
2.desc    dept       ²¿Ãűí
3.desc salgrade      нˮµÈ¼¶
4.select *from table ²éÕÒ±íÖеÄÔªËØ
5.dual               ÊÇϵͳÖеÄÒ»ÕÅ¿Õ±í
6.select *from dual 
7.select sysdate from dual  È¡³öϵͳʱ¼ä
8.select ename,sal*12 "annul sal"(È¡µÄ±ðÃû£© from emp; ²éÕÒÓû§ÐÕÃûºÍÓû§µÄÄêн
9.Èκκ¬ÓпÕÖµµÄÊýѧ±í´ïʽµÄÖµ¶¼ÊÇ¿ÕÖµ
  select ename,sal*12+comm from emp;
10.select ename||sal from emp ÆäÖеÄ||Ï൱ÓÚ½«salÈ«²¿×ª»¯Îª×Ö·û´®
11.±íʾ×Ö·û´®µÄ·½·¨
  select ename ||'ajjf' from emp;
12.Èç¹ûÆäÖÐÓÐÒ»¸öµ¥ÒýºÅ¾ÍÓÃ2¸öµ¥ÒýºÅÀ´´úÌæËû
  select ename||'sakj' 'lds'from emp;
13.select distinct deptno from emp     (È¥³ý²¿ÃÅ×Ö¶ÎÖÐÖظ´µÄ²¿·Ö,¹Ø¼ü×Ödistinct)
14.select distinct deptno,job from emp;(È¥³ýÕâ2¸ö×Ö¶ÎÖÐÖظ´µÄ×éºÏ)
15.select *from dept where deptno=10;     È¡³öÌõ¼þ(È¡³ö²¿ÃűàºÅΪ10µÄ¼Ç¼)
16.select * from emp where ename='CLIRK'; È¡³ö²¿ÃÅÖÐÐÕÃûΪclirkµÄ¼Ç¼(×¢ÒâÈ¡³ö¹ý³ÌÖÐenameÓõ¥ÒýºÅ¸ô¿ª)
17.select ename,sal from emp where sal>1500; È¡³ö²¿ÃÅÖÐнˮ´óÓÚ1500µÄÈ˵ÄÐÕÃû
18.select ename,sal,deptno from emp where deptno<> 10 È¡³ö²¿ÃÅÖеIJ¿ÃźŲ»µÈÓÚ10µÄ
19.select ename,sal,deptno from emp where ename>'CBA' È¡³ö²¿ÃÅÖÐÔ±¹¤Ãû×Ö´óÓÚCBAµÄÔ±¹¤(ʵ¼Ê±È½ÏµÄÊÇACIISÂë)
20.select ename,sal from emp where sal between 800 and 1500
   select ename,sal from emp where sal>=800 and sal<=1500;   (È¡³ö800ºÍ1500Ö®¼äµÄÊý)
21.select ename,sal,comm from emp where comm is null (Ñ¡³öÆäÖеĿÕÖµ)
   select enmae,sal,comm from emp where comm is not null(Ñ¡³öÆäÖеķǿÕÖµ)
22.select ename,sal,comm from emp where sal in (800,1500,2000);È¡³öÕâ3ÕßÖ®ÖеÄ
   select ename,sal,comm from emp where ename in('simth');
23.select ename,sal,hiredate from emp where hiredata>'3-04ÔÂ-81';Ðû´«·ûºÏÌõ¼þµ