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

Oracle×Ó²éѯ

×Ó²éѯ
 µ¥ÐÐ×Ó²éѯ(single-row subqueries)
    Ê¹ÓõÄÔËËã·ûºÅ(=,>,<,>=,<=,<>)
  ¶àÐÐ×Ó²éѯ(multiple-row subqueries)
    Ê¹ÓõÄÔËËã·ûºÅ(in,not in,exists,not exits,all,any)
   Ïà¹Ø×Ó²éѯ(correlated subqueries)
    ¸ñʽ select ÁÐÃû,(select Óï¾ä) from ±íÃû
   ±êÁ¿×Ó²éѯ(scalar subqueries)
    ×Ó²éѯÊÇ·µ»Øµ¥Ðе¥ÁÐ,¸ñʽͬÉÏ
   ¶àÁÐ×Ó²éѯ(multiple-column subqueries)
   ÔÚDDLÓï¾äÖÐʹÓÃ×Ó²éѯ
   ÔÚDMLÓï¾äÖÐʹÓÃ×Ó²éѯ
--------
µ¥ÐÐ×Ó²éѯ
 --ÏÔʾ¹¤×Ê×î¸ßµÄ¹ÍÔ±ÐÅÏ¢
 Select ename,deptno,sal from emp
 Where sal=(select max(sal) from emp);
--------
¶àÐÐ×Ó²éѯ
 --ÏÔʾÓ벿ÃűàºÅΪ20µÄ¸ÚλÏàͬµÄ¹ÍÔ±ÐÅÏ¢
 Select ename,deptno,sal,job from emp
 Where job in (select distinct job from emp where deptno=20);
 --ÏÔʾ²»Ó벿ÃűàºÅΪ20µÄ¸ÚλÏàͬµÄ¹ÍÔ±ÐÅÏ¢
 Select ename,deptno,sal,job from emp where job not in (select distinct job from emp where deptno=20);
 --ÏÔʾ¸ßÓÚ²¿ÃűàºÅΪ20µÄËùÓйÍÔ±µÄ¹¤×ʵĹÍÔ±ÐÅÏ¢
 select ename,deptno,sal ,job from emp
 where sal>all(select sal from emp where deptno=20);
 --ÏÔʾ¸ßÓÚ²¿ÃűàºÅΪ20µÄÈκιÍÔ±µÄ¹¤×ʵĹÍÔ±ÐÅÏ¢
 select ename,deptno,sal ,job from emp
 where sal>any(select sal from emp where deptno=20); 
---------
Ïà¹Ø×Ó²éѯ
 --ÏÔʾÿ¸ö²¿ÃŵÄ×î¸ß¹¤×ʵĹÍÔ±ÐÅÏ¢
 select deptno,(select max(sal) from emp b where b.deptno=a.deptno) maxsal
 from emp a order by deptno;
 --Ôö¼Ódistinct
 select distinct deptno,(select max(sal) from emp b where b.deptno=a.deptno) maxsal
 from emp a order by deptno;
 --ÏÔʾ¹¤×÷ÔÚNEW YORKµÄ¹ÍÔ±ÐÅÏ¢
 select ename,deptno,sal,job from emp
 where exists (select 'x' from dept where dept.deptno=emp.deptno and dept.loc='NEW YORK');
---------
±êÁ¿×Ó²éѯ
 --·µ»Øµ¥Ðе¥ÁÐ
 Select count(*) from emp;
 Select sum(sal)


Ïà¹ØÎĵµ£º

Oracle ÊÓͼ

Oracle ÊÓͼ
    ÊÓͼ: Äã¿ÉÒÔͨ¹ý´´½¨±íµÄÊÓͼÀ´±íÏÖÊý¾ÝµÄÂß¼­×Ó¼¯»òÊý¾ÝµÄ×éºÏ.ÊÓͼÊÇ»ùÓÚ±í»òÕßÁíÒ»¸ö
          ÊÓͼµÄÂß¼­±í,Ò»¸öÊÓͼ²¢²»°üº¬Ëü×Ô¼ºµÄÊý¾Ý,ËüÏóÒ»¸ö´°¿Ú,ͨ¹ý¸Ã´°¿Ú¿ÉÒԲ鿴»ò¸Ä±ä
         ......

oracleÖØ½¨Ë÷Òý

Ö£ÖØËµÃ÷£º´ËÎÄÀ´×ÔÓÚÍøÂ磬ÈçÓÐÇÖȨÇë¸æÖ®£¡
µ¼¶Á£º
¡¡¡¡Öؽ¨Ë÷ÒýÓжàÖÖ·½Ê½£¬Èçdrop and re-create¡¢rebuild¡¢rebuild onlineµÈ¡£ÏÂÃæ¼òµ¥±È½ÏÕ⼸ÖÖ·½Ê½ÒìͬÒÔ¼°ÓÅȱµã£º
¡¡¡¡Ê×ÏȽ¨Á¢²âÊÔ±í¼°Êý¾Ý£º
¡¡¡¡SQL> CREATE TABLE TEST AS SELECT CITYCODE C1 from CITIZENINFO2;
¡¡¡¡Table created
¡¡¡¡SQL> ALTE ......

Oracle ±íµÄÒÆ¶¯ºÍË÷ÒýµÄÖØ½¨

ÔµÆðÒ»¸ö±í¿Õ¼äÌ«´ó,ɾ³ýÊý¾ÝºóÓÉÓÚÎļþβ±»ÓÃ,ÎÞ·¨resize,´òËã°ÑËùÓбí¿Õ¼äÉϵĶÔÏómoveµ½Ò»¸öÁÙʱ´æ´¢µÄ±í¿Õ¼ä×öÕûÀí¡£
moveÒ»¸ö±íµ½ÁíÍâÒ»¸ö±í¿Õ¼äʱ,Ë÷Òý²»»á¸ú×ÅÒ»Æðmove£¬¶øÇÒ»áʧЧ¡££¨LOBÀàÐÍÀýÍ⣩±ímove£¬ÎÒÃÇ·ÖΪ£º
*ÆÕͨ±ímove
*·ÖÇø±ímove
*LONG,LOB´ó×Ö¶ÎÀàÐÍmoveÀ´½øÐвâÊÔºÍ˵Ã÷¡£
Ë÷ÒýµÄmove£¬ÎÒÃÇÍ ......

Oracle 10gÖиúEMÓйصÄÎÊÌâ½â¾ö·½·¨

Oracle 10gÖеÄEM²ÉÓÃWebµÄÐÎʽÀ´¹ÜÀíÊý¾Ý¿â¼°Ïà¹Ø·þÎñ£¬µ«Ê¹Óùý³ÌÖлáÅöµ½Ò»Ð©¸úEMÓйصÄÎÊÌ⣬¸ù¾ÝͬÐеÄÌáʾ¼°±ÊÕßµÄʵ¼Ê¾­Ñ飬½øÐÐÁËһЩ¹éÄÉ£¬Ï£Íû¶ÔÏà¹Ø°®ºÃÕßÓÐËù°ïÖú£º
£¨1£©Êý¾Ý¿â¿ØÖÆÌ¨Æô¶¯ºó£¬¿´µ½1£©Êý¾Ý¿âʵÀýÎÞÐÅÏ¢2£©¼àÌý³ÌÐòΪ״̬Ϊ²»¿ÉÓÃ3£©µ½ÊµÀýµÄ´úÀíÁ¬½Ó״̬Ϊ²»¿ÉÓá£
ÎÊÌâ·ÖÎö£º
´Ëʱ·þÎñ¸ÕÆô ......

Oracle»ù´¡

---------------oracle ÈëÃÅ
 ´ò¿ª·þÎñÆ÷
 net start oracleserviceORCL
 ´ò¿ª¼àÌýÆ÷
 lsnrctl start
 ¹Ø±Õ·þÎñÆ÷
 net stop oracleserviceORCL
 ¹Ø±Õ¼àÌýÆ÷
 lsnrctl stop
-----------------------------
 1.´´½¨±í
 Create table ±íÃû
 (×Ö¶ÎÃû Êý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ