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

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;


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿â½µµÍHWMµÄ¼¸ÖÖ·½·¨

HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øϽµ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......

ORACLE Êý¾Ý¿âÂß¼­±¸·Ý ¼òµ¥ EXP/IMP

 ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý¿â±ØÐëÔËÐÐÔڹ鵲ģʽÏ£¨ÒµÎñÊý¾Ý¿âÔڷǹ鵲ģʽÏÂÔËÐУ©£¬ÇÒÐèÒª¼«´óµÄÍⲿ´æ´¢É豸£¬ÀýÈç´Å´ø¿â£»µÚ¶þÀ౸·Ý·½Ê½ÎªÂß¼­±¸·Ý£¬ÒµÎñÊý¾Ý¿â²ÉÓôËÖÖ·½Ê½£¬´Ë·½·¨²»ÐèÒªÊý¾Ý¿âÔËÐÐÔڹ鵲ģʽÏ£¬²»µ«±¸·Ý¼òµ¥£¬¶øÇÒ¿ÉÒÔ²»ÐèÒªÍⲿ´æ ......

Oracle USERENVºÍsys_context

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 ......

¼×¹ÇÎÄÍƳöOracle PeopleSoft Enterprise 9.1

ΪÁË°ïÖúÆóÒµÌá¸ßÔ±¹¤Ð§Á¦£¬¼×¹ÇÎĹ«Ë¾ÈÕÇ°ÔÚ2009¼×¹ÇÎÄÈ«Çò´ó»áÉÏÍƳö×îаæOracle PeopleSoft Enterprise¹ÜÀíÈí¼þ£¬¼´PeopleSoft EnterpriseÈËÁ¦×ʱ¾¹ÜÀí9.1¡¢PeopleSoft Enterprise PeopleTools 8.50¡¢PeopleSoft Enterpriseѧϰ¹ÜÀí9.1ºÍPeopleSoft EnterpriseÃÅ»§9.1¡£¡¡¡¡Õâ¸öÎüÊÕÁËÀ´×Ô150¶à¸ö¿Í»§µÄ·´À¡ÐÅÏ¢ ¶ø¿ª·¢ ......

oracleÓû§È¨Ï޵IJéѯ

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.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ