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;
Ïà¹ØÎĵµ£º
Ô´´ÓÚ2007Äê04ÔÂ12ÈÕ£¬2009Äê10ÔÂ15ÈÕÇ¨ÒÆÖÁ´Ë¡£
windows xp£¬Êý¾Ý¿âoracle 10.2.0¡£1
ûÓб¸·Ý£¬»ù±¾ÉÏÊÇĬÈϰ²×°£¬ºÃÏñ»¹²»Êǹ鵵ģʽ
Ö¢×´£ºsqlplusÖ»ÓÐsysdbaÓû§ÄܽøÈ¥£¬ÆäËûÓû§½øÈ¥Ò»¸Å±¨£ºora-01033£ºoracleÕýÔÚ³õʼ»¯»ò¹Ø±Õ
¶øÇÒsysdbaÓû§½øÈ¥Ö®ºóÄÜÖ´ÐÐselect sysdate from dual£¬µ«ÊÇÖ´ÐÐselect use ......
ǰ¼¸ÌìÃæÊÔµÄʱºòÃæÊÔ¹Ù²ÅÎʹýÎÒORACLEµÄÌåϵ½á¹¹£¬ÈÃÎÒÔÚÒ»ÕŰ×Ö½ÉÏ»³öÀ´¡£»ØÍ·ÏëÏ뵱ʱ´ðµÃ»¹²»´í£¬´ó²¿·ÖÄÚÈݶ¼ÃèÊö³öÀ´ÁË£¬ºÇºÇ£¬¸Õ²ÅÔÚÍøÉÏ¿´µ½Ò»Æª½²½âORACLEÌåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......
OracleÊý¾Ý¿âº¯Êý£¨µ¥Ðк¯Êý£©
OracleÖеĺ¯ÊýºÍCÖеĺ¯Êý²î²»¶à£¬Ò²ÊÇÓк¯ÊýÃû£¬²ÎÊý±í£¬ºÍ·µ»ØÖµÀàÐÍ×é³ÉµÄ£¬µ¥Ðк¯Êý£¬ÊÇÕë¶ÔÿÌõ¼Ç¼¶¼ÓÐÒ»¸ö½á¹û¡£µ¥Ðк¯Êý¿ÉÒÔ³öÏÖÔÚselect ºóÃæ£¬Ò²¿ÉÒÔ³öÏÖÔÚwhere×Ó¾äÖС£
ÐèÒª´¦ÀíÏÖʵµÄ½á¹ûʱ£¬¾Í°Ñº¯ÊýдÔÚselectºóÃæ£¬ÓÃÓÚÌõ¼þ¹ýÂËʱ£¬¾Í°Ñº¯Êý ......
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.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óà ......