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

oracleÊ÷ÖÐpriorµÄÓ÷¨

Êý¾Ý˵Ã÷Ò»ÇУº
create table dept(deptno number,deptname varchar2(20),mgrno number);
insert into dept values (1, '×ܹ«Ë¾', null);
insert into dept values (2, 'Õã½­·Ö¹«Ë¾', 1);
insert into dept values (3, 'º¼ÖÝ·Ö¹«Ë¾', 2);
commit;
select t.* from dept t;
      DEPTNO    DEPTNAME    MGRNO
1    1    ×ܹ«Ë¾   
2    2    Õã½­·Ö¹«Ë¾    1
3    3    º¼ÖÝ·Ö¹«Ë¾    2
select *  from dept   connect by prior mgrno=deptno ; --ÒÔ×Ó½áµãΪ¿ªÊ¼Ïò¸ù½áµã±éÀú
      DEPTNO    DEPTNAME    MGRNO
1    1    ×ܹ«Ë¾   
2    2    Õã½­·Ö¹«Ë¾    1
3    1    ×ܹ«Ë¾   
4    3    º¼ÖÝ·Ö¹«Ë¾    2
5    2    Õã½­·Ö¹«Ë¾    1
6    1    ×ܹ«Ë¾   
 select  *  from dept start with mgrno=1 connect by prior mgrno=deptno ---ÒÔ×Ó½áµãΪ¿ªÊ¼ÇÒ¿ªÊ¼Îª1£¬µÄ±éÀú
       DEPTNO    DEPTNAME    MGRNO
1    2    Õã½­·Ö¹«Ë¾    1
2    1    ×ܹ«Ë¾   
-------------------------------------------------------------------------------------------------------------
select   from dept  connect by prior deptno= mgrno
        DEPTNO    DEPTNAME    MGRNO
1    2    Õã½­·Ö¹«Ë¾    1
2    3    º¼ÖÝ·Ö¹«Ë¾    2
3    3    º¼ÖÝ·Ö¹«Ë¾    2
4&nbs


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracleµÄ×óÓÒÁ¬½Ó

¶Ô×óÁ¬½Ó¡¢ÓÒÁ¬½ÓµÄÒÉ»óµÃµ½½â¾ö¡£
ÔÚOracle PL-SQLÖУ¬×óÁ¬½ÓºÍÓÒÁ¬½ÓÒÔÈçÏ·½Ê½À´ÊµÏÖ
²é¿´ÈçÏÂÓï¾ä£º
SELECT emp_name, dept_name
FORM Employee, Department
WHERE Employee.emp_deptid(+) = Department.deptid
      ´ËSQLʹÓÃÁËÓÒÁ¬½Ó£¬¼´“(+)”ËùÔÚλÖõÄÁíÒ»²àΪÁ¬½Óµ ......

²é¿´Oracle±í¿Õ¼äʹÓÃÇé¿öSQLÓï¾ä

 select f.tablespace_name,a.total,u.used,f.free,round((u.used/a.total)*100) "% used", round((f.free/a.total)*100) "% Free"
from
(select tablespace_name, sum(bytes/(1024*1024)) total
from dba_data_files group by tablespace_name) a,
(select tabl ......

³£ÓÃSQLÓï¾ä£¨Oracle£©(ת)

ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
   ×Ö·ûÐÍ    char        ·¶Î§  ×î´ó2000¸ö×Ö½Ú ¶¨³¤
               char(10)   'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú  'ÕÅÈý &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ