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

ORACLEµÄһЩ²éѯ


Ò»¡¢ÐèÒª²éѯµÄÊý¾Ý
1
¡¢²éѯ³öÔÂн´óÓÚ
'SMITH'
µÄËùÓÐÔ±¹¤×ÊÁÏ
    select *from emp where
sal>(select sal from emp where name="SMITH");
2
¡¢²éѯËùÓÐÔ±¹¤µÄÐÕÃû¼°Áìµ¼ÐÕÃû
    select e1.ename,e2.ename from
emp e1,emp e2 where e1.mgr=e2.empno(+);
3
¡¢²éѯ³öÈëÖ°ÈÕÆÚÔçÓÚÁìµ¼µÄËùÓÐÔ±¹¤±àºÅ£¬ÐÕÃû£¬²¿ÃÅÃû³Æ¡£
   
ÏȲé³öÔ±¹¤ÐÕÃû£¬Áìµ¼ÐÕÃû£¬ÈëְʱÆÚ
.
   
ÔÚÌâÄ¿
2
µÄ»ù´¡ÉÏ£¬¶àÔö¼ÓÒ»¸öÈëÖ°ÈÕÆÚÌõ¼þ£¬Ôö¼Ó
deptno
±í£¬Ôö¼ÓÈ¥³ýµÑ¿¨¶û»ýµÄ¹ØÁªÌõ¼þ
select
e1.empno,e1.ename,e2.ename,d.dname from emp e1,emp e2,dept d where
e1.mgr=e2.empno(+) and e1.hiredate<e2.hiredate and e1.deptno=d.deptno;
4
¡¢²é³ö²¿ÃÅÃû³ÆºÍ²¿ÃÅÔ±¹¤ÐÅÏ¢
(
ûÓÐÔ±¹¤µÄ²¿ÃÅÒ²ÐèÒªÌåÏÖ
)
select
d.dname,e.ename,e.job,e.mgr,e.hiredate,e.sal,e.comm,e.deptno
from
dept d,emp e
where
d.deptno=e.deptno(+);
5
¡¢²é³öְλÊÇ“
CLERK
”µÄÐÕÃû¼°Æä²¿ÃÅÃûºÍ²¿ÃÅÈËÊý
select
e.ename,d.dname,t.c
    from emp e,dept d,(select
deptno,count(empno) c from emp where job='CLERK'
    group by deptno) t
    where e.job='CLERK' AND e.deptno=d.deptno
and e.deptno=t.deptno;
6
¡¢²é³ö×îµÍ¹¤×Ê´óÓÚ
1500
µÄ¸÷ÖÖ¹¤×÷¼°Æä´ÓÊÂÕâЩ¹¤×÷µÄÈ«²¿Ô±¹¤ÈËÊý¡£
ÒÑÖªÌõ¼þ£º
min(sal)>1500
 
6.1
¡¢²é´¦Ã¿¸ö²¿ÃÅÖÐ×îµÍ¹¤×ʵÄÔ±¹¤ÐÅÏ¢¡£
select
deptno,min(sal)  from emp group by
deptno;
6.2
¡¢²é³öְλ¹¤×ʵÄ×îµÍ¹¤×Ê´óÓÚ
1500
µÄËùÓй¤×÷ºÍ¹¤×Ê¡£
Select
job,min(sal) from emp group by job having min(sal)>1500
6.3
¡¢²éѯ³öËùÓÐְ룬ÒÔ¼°´ÓÊÂÕâ¸öְλµÄÈËÊý¡£
Select
job,count(empno) from emp group by job;
6.4
ºÏ²¢³ö×îºó½á¹û£º
Select job,min(sal),count(empno) from
emp group by job having min(sal)>1500


Ïà¹ØÎĵµ£º

ORACLE Óë mysql µÄÇø±ð

 1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ² ......

Oracle»ØÊÕÕ¾£¬ora 38301´íÎó

ora-38301´íÎó,»ØÊÕÕ¾
ǰ¼¸ÌìÓÐͬʸæËßÎÒ£¬ÓÐ̨·þÎñÆ÷Éϵıí¿Õ¼äÎÞ·¨É¾³ý£¬ÈÃÎÒ¿´¿´¡£µÇ¼µ½·þÎñÆ÷£¬É¾³ý±í¿Õ¼ä£¬Êý¾Ý¿âͬʱ±¨ora-00604ºÍora-38301´íÎ󡣯ð³õÒÔΪÊÇÓÐÊý¾Ý¿â¶ÔÏó±»Ëø¶¨£¬ÖØÆôÊý¾Ý¿âºó£¬·¢ÏÖ»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£Googleºó·¢ÏÖ¿ÉÄÜÓë10gµÄÒ»¸öÐÂÌØÐÔ»ØÊÕÕ¾Óйأ¬Çå¿Õ»ØÊÕÕ¾purge recyclebinºó£¬½øÐÐɾ³ý»¹ÊDZ ......

¡¾×ª¡¿oracle´óÊý¾ÝÁ¿µÄµ¼ÈëºÍµ¼³ö

ÔÚoracleÖÐÅúÁ¿Êý¾ÝµÄµ¼³öÊǽèÖúsqlplusµÄspoolÀ´ÊµÏֵġ£ÅúÁ¿Êý¾ÝµÄµ¼ÈëÊÇͨ¹ýsqlloadÀ´ÊµÏֵġ£
´óÁ¿Êý¾ÝµÄµ¼³ö²¿·ÖÈçÏ£º
/***************************
 *  sql½Å±¾²¿·Ö demo.sql begin
 **************************/
/**************************
 * @author meconsea
 * @date 20050 ......

ͼƬ¶þ½øÖÆ´æÈëORACLEºÍд³ö

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Syste ......

Oracle·ÖÇø¼¼Êõ

ORACLEµÄ·ÖÇø(Partitioning Option)ÊÇÒ»ÖÖ´¦Àí³¬´óÐͱíµÄ¼¼Êõ¡£·ÖÇøÊÇÒ»ÖÖ“·Ö¶øÖÎÖ®”µÄ¼¼Êõ£¬Í¨¹ý½«´ó±íºÍË÷Òý·Ö³É¿ÉÒÔ¹ÜÀíµÄС¿é£¬´Ó¶ø±ÜÃâÁ˶Ôÿ¸ö±í×÷Ϊһ¸ö´óµÄ¡¢µ¥¶ÀµÄ¶ÔÏó½øÐйÜÀí£¬Îª´óÁ¿Êý¾ÝÌṩÁË¿ÉÉìËõµÄÐÔÄÜ¡£·ÖÇøÍ¨¹ý½«²Ù×÷·ÖÅ䏸¸üСµÄ´æ´¢µ¥Ôª£¬¼õÉÙÁËÐèÒª½øÐйÜÀí²Ù×÷µÄʱ¼ä£¬²¢Í¨¹ýÔöÇ¿µÄ²¢Ðд ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ