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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¶Ô×óÁ¬½Ó¡¢ÓÒÁ¬½ÓµÄÒÉ»óµÃµ½½â¾ö¡£
ÔÚOracle PL-SQLÖУ¬×óÁ¬½ÓºÍÓÒÁ¬½ÓÒÔÈçÏ·½Ê½À´ÊµÏÖ
²é¿´ÈçÏÂÓï¾ä£º
SELECT emp_name, dept_name
FORM Employee, Department
WHERE Employee.emp_deptid(+) = Department.deptid
´Ë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 ......
ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
×Ö·ûÐÍ char ·¶Î§ ×î´ó2000¸ö×Ö½Ú ¶¨³¤
char(10) 'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú 'ÕÅÈý &nb ......