OracleÖÐrownumµÄÓ÷¨
1¡¢²éѯµÚ¼¸ÐеļǼ
select sal from emp where rownum=1; //²éѯµÃµ½µÚÒ»ÐмǼ
select sal from emp where rownum=5; //²»¿ÉÒÔ²éѯµ½µÚÎåÐмǼ£¬ÒòΪrownum ×ÜÊÇ´Ó1¿ªÊ¼²éѯµÄ£¬¹ÊÕâÖÖ·½Ê½²»¿ÉÒÔÖ±½ÓµÃµ½µÚ¼¸ÐеļǼ¡£ÈôÏëµÃµ½µÚÎåÐмǼ£¬Ó¦²ÉÓÃÈçÏ·½Ê½£º
select r,sal from (select rownum r,sal from emp) where r= 5;
2¡¢ÓÃÀ´»ñÈ¡Ç°¼¸ÐеļǼ£¬¼´Ð¡ÓÚijֵµÄ¼Ç¼¡£
Àý£º²éѯǰËÄÐеļǼ
select rownum,sal from emp where rownum<5;
3¡¢ÓÃÀ´»ñÈ¡ºó¼¸ÐеļǼ£¬¼´´óÓÚijֵµÄ¼Ç¼¡£Àý£º²éѯµÚÎåÐÐÖ®ºóµÄ¼Ç¼
select r,sal from (select rownum r,sal from emp ) where r>5;
4¡¢²éѯһ¸ö·¶Î§ÄڵļǼ¡£Èç²éѯµÚÈýÐе½µ×°ËÐеļǼ£º
select r,sal from (select rownum r,sal from emp) where r>=3 and r<=8;
5¡¢rownum ÓëÅÅÐò
select rownum,sal from emp order by sal;
´ÓÕâÌõÓï¾äµÄÔËÐнá¹ûÄã¿ÉÒÔ·¢ÏÖ£¬rownum²»ÊÇ´Ó1 Ò»´ÎÔö´ó£¬¶øÊÇÂҵģ¬Êµ¼ÊÉÏÕâЩrownumÊÇָÿÌõ¼Ç¼δÅÅÐò֮ǰËù´¦µÄÐÐÊý£¬µ±È»Õâ²»ÊÇÎÒÃÇÏëÒªµÄ½á¹û£¬ÄÇôÈçºÎµÃµ½rownumÒ²ÊÇ˳ÐòÅÅÁеIJéѯ½á¹ûÄØ£¿Õâ¾ÍÐèÒªÏȶÔԼͼÅÅÐò£¬È»ºó´ÓеÄ˳ÐòÖÐÌáÈ¡³örownumºÍÏëÒªµÄ¼Ç¼ÄÚÈÝ¡£È磺
select rownum,sal from (select * from emp order by sal) ;
select rownum, sal from (select * from emp order by sal ) where rownum <5;
select r, sal from (select rownum r,sal from (select * from emp order by sal )) where r >5;
select r, sal from (select rownum r,sal from (select * from emp order by sal ))
where r >5 and r < 10;
Ïà¹ØÎĵµ£º
HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øϽµ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......
ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý¿â±ØÐëÔËÐÐÔڹ鵲ģʽÏ£¨ÒµÎñÊý¾Ý¿âÔڷǹ鵲ģʽÏÂÔËÐУ©£¬ÇÒÐèÒª¼«´óµÄÍⲿ´æ´¢É豸£¬ÀýÈç´Å´ø¿â£»µÚ¶þÀ౸·Ý·½Ê½ÎªÂß¼±¸·Ý£¬ÒµÎñÊý¾Ý¿â²ÉÓôËÖÖ·½Ê½£¬´Ë·½·¨²»ÐèÒªÊý¾Ý¿âÔËÐÐÔڹ鵲ģʽÏ£¬²»µ«±¸·Ý¼òµ¥£¬¶øÇÒ¿ÉÒÔ²»ÐèÒªÍⲿ´æ ......
1.USEREVN()
·µ»Øµ±Ç°Óû§»·¾³µÄÐÅÏ¢,opt¿ÉÒÔÊÇ:
ENTRYID,SESSIONID,TERMINAL,ISDBA,LABLE,LANGUAGE,CLIENT_INFO,LANG,VSIZE
1.ISDBA ²é¿´µ±Ç°Óû§ÊÇ·ñÊÇDBAÈç¹ûÊÇÔò·µ»Øtrue
SQL> select userenv('isdba') from dual;
USEREN
------
FALSE
2.SESSION ·µ»Ø»á»°±êÖ¾
SQL> select userenv('sessio ......
ΪÁË°ïÖúÆóÒµÌá¸ßÔ±¹¤Ð§Á¦£¬¼×¹ÇÎĹ«Ë¾ÈÕÇ°ÔÚ2009¼×¹ÇÎÄÈ«Çò´ó»áÉÏÍƳö×îаæOracle PeopleSoft Enterprise¹ÜÀíÈí¼þ£¬¼´PeopleSoft EnterpriseÈËÁ¦×ʱ¾¹ÜÀí9.1¡¢PeopleSoft Enterprise PeopleTools 8.50¡¢PeopleSoft Enterpriseѧϰ¹ÜÀí9.1ºÍPeopleSoft EnterpriseÃÅ»§9.1¡£¡¡¡¡Õâ¸öÎüÊÕÁËÀ´×Ô150¶à¸ö¿Í»§µÄ·´À¡ÐÅÏ¢ ¶ø¿ª·¢ ......
oracleÖв鿴Óû§È¨ÏÞ
1.²é¿´ËùÓÐÓû§£º
select * from dba_users;
select * from all_users;
select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ(Ö±½Ó¸³Öµ¸øÓû§»ò½ÇÉ«µÄϵͳȨÏÞ)£º
select * from dba_sys_privs;
select * from user_sys_privs;
3.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óà ......