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

OracleÖм¸¸öµäÐ͵ĹØÓÚº¯Êý²éѯ_3ÔÂ5ÈÕ

Ò»¡¢ÔÚ²»ÖªµÀ²¿ÃÅ“SALES”µÄ²¿ÃűàºÅµÄÇé¿öÏ£¬²é³ö´Ë²¿ÃŵÄËùÓÐÔ±¹¤ÐÕÃû¡£
select e.ename
from emp e
where e.deptno=(select deptno from dept  where dname='SALES');
 
2¡¢²éѯ³öÔÂн¸ßÓÚ¹«Ë¾Æ½¾ùÔÂнµÄËùÓÐÔ±¹¤±àºÅ£¬ÐÕÃû£¬ËùÓв¿ÃűàºÅ£¬²¿ÃÅÃû³Æ£¬Éϼ¶Áìµ¼Ãû£¬ÒÔ¼°
ËûµÄ¹¤×ʵȼ¶¡£
SELECT
e.empno,e.ename,e.deptno,d.deptno,d.dname,e1.ename,s.grade
from emp e,emp e1,dept d,salgrade s
where e.mgr=e1.empno(+) and e.deptno=d.deptno and e.sal between s.losal and s.hisal and
e.sal>(select avg(sal) from emp);
 
3¡¢²éѯ³öÓë"SCOTT"´ÓÊÂͬһ¹¤×÷µÄËùÓÐÔ±¹¤¼°²¿ÃÅÃû³Æ¡£(²»°üÀ¨scott,ÓÃ<>Ò²¿ÉÒÔ)
select e.ename,d.dname from emp e,dept d where job=(select job from emp where
ename='SCOTT') and e.deptno=d.deptno and e.ename!='SCOTT';
4¡¢²éѯ³öÔÂнµÈÓÚ²¿ÃÅ30ÖÐÔ±¹¤µÄÔÂнµÄËùÓÐÔ±¹¤ÐÕÃûºÍÔÂн¡£
select e.ename,e.sal from emp e where e.sal in (select sal from emp  where deptno=30) and  deptno!=30;
5¡¢²é³öÔÂн¸ßÓÚ²¿ÃÅ30¹¤×÷µÄËùÓÐÔ±¹¤ÔÂнµÄ£¬Ô±¹¤ÐÕÃû£¬²¿ÃÅÃû¡£
All(²éѯÓï¾ä):>×î´óÖµ£¬<×îСֵ
in() ÔÙÕâ¸ö·¶Î§ÄÚÓÐûÓÐ
any()±ÈÀïÃæ×îСµÄ´ó£¬±È×î´óµÄС£»
SELECT
e.ename,d.dname
from
emp e,dept d
where e.sal>(select max(sal) from emp where deptno=30) and e.deptno=d.deptno and e.deptno<>30;
6¡¢²éѯ³öÿ¸ö²¿ÃÅÃû£¬Ô±¹¤×ÜÊý£¬Æ½¾ù¹¤×Ê£¬Æ½¾ù·þÎñÄêÏÞ¡£
month_between(sysdate,e.hiredate)/12
//Á½¸öʱ¼ä²î¶àÉÙ¸öÔÂ/12ÊDzî¶àÉÙÄê
select d.dname,count(e.empno),avg(e.sal),avg(months_between(sysdate,e.hiredate)/12)
from emp e,dept d
where e.deptno(+)=d.deptno
group by d.dname;
 


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿â°æ±¾±äǨÀúÊ·

·1979ÄêµÄÏļ¾£¬RSI·¢²¼ÁËOracleµÚ¶þ°æ
·1983Äê3Ô£¬RSI·¢²¼ÁËOracleµÚÈý°æ
´ÓÏÖÔÚÆðOracle²úÆ·ÓÐÁËÒ»¸ö¹Ø¼üµÄÌØÐÔ:¿ÉÒÆÖ²ÐÔ
·1984Äê10Ô£¬Oracle·¢²¼Á˵Ú4°æ²úÆ·
ÕâÒ»°æÔö¼ÓÁ˶ÁÒ»ÖÂÐÔÕâ¸öÖØÒªÌØÐÔ
·1985Ä꣬Oracle·¢²¼ÁË5.0°æ
Õâ¸ö°æ±¾ËãµÃÉÏÊÇOracleÊý¾Ý¿âµÄÎȶ¨°æ±¾¡£ÕâÒ²ÊÇÊ ......

oracle 10g ´íÎó ORA 01653 µÄ½â¾ö¹ý³Ì

ÔçÉÏÓû§·´Ó¦ÔÚ²Ù×÷ÓÃÓÑNCʱ±¨´í ORA-01653 £¬ÏêϸÐÅÏ¢£ºORA-01653: ±í NCV35.GL_DETAIL ÎÞ·¨Í¨¹ý 1024 (ÔÚ±í¿Õ¼ä NNC_DATA01 ÖÐ) À©Õ¹¡£
ÔÚÈÕÖ¾Îļþ F:\oracle\product\10.2.0\admin\CUTC\bdump\alert_cutc.logÖУ¬³öÏÖ
Thu Mar 04 10:59:21 2010
ORA-1653: unable to extend table NCV35.GL_DETAIL by 1024 in&nb ......

Oracleѧϰ±Ê¼ÇһʵÀý


Oracleѧϰ±Ê¼ÇһʵÀý
             ——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
 
Oracleѧϰ±Ê¼ÇһʵÀý
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
Oracleѧϰ±Ê¼ÇÈý·½°¸
ʵÀý
     ÔÚOracleºÍSqlServerÖж¼ÓÐʵÀýһ˵£¬µ«ÕâÁ½¸öʵÀýÊDz»Í¬µÄ¡£
     ÔÚSql ......

Oracleѧϰ±Ê¼Ç¶þ´æ´¢

Oracleѧϰ±Ê¼Ç¶þ´æ´¢
                                         ——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
´æ´¢
   ÔÚSqlServerÖУ¬ÎÒÃÇ¿ÉÒÔΪһ¸öÊý¾Ý¿âÖ¸¶¨Ò»×éÎļþ¡£Êý¾Ý´æ´¢ÔÚÕâЩÎļþÖС£
& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ