oracleµÄËæ»úÅÅÐò
ÏîÄ¿ÀïÒ»¸ö¹¦ÄÜÒªÓõ½Ëæ»úÅÅÐò£¬µ«ÊǺóÀ´ÓÖÒòΪÊý¾ÝÁ¿´óµÄÔÒò£¬Òª·Öҳȥ²éѯÊý¾Ý£¬½á¹ûµ¼Ö²éѯ³öÀ´µÄÊý¾Ý³öÏÖÖØ¸´¡£
ÔsqlÈçÏÂselect * from ( select row_.*, rownum rownum_ from
(select * from tble order by dbms_random.random) row_ where rownum <= 12) where rownum_ > 10;
ºóÀ´½â¾ö°ì·¨£¬²åÈëÒ»ÕÅÁÙʱ±í¼ÇÂ¼Ëæ»ú³öÀ´µÄÊý¾Ý£¬È»ºó°´ÁÙʱ±í·Öҳȥ²é£¬Ïë²»µ½ºÃ°ì·¨£¬Ö»Äܵ±ÈÎÎñÀ´Íê³ÉÁË¡£
¹ýÂ˵ôorder by µÄÅÅÐòÕýÔò
sql = sql.replaceAll("order by [^\\)]+", "");
Ïà¹ØÎĵµ£º
--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
--ÉùÃ÷Óαê
cursor mycur is select * from employees where employee_id<120;
--¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓ ......
Oracle»ù±¾¸ÅÄî/ÊõÓï
Êý¾Ý¿â£¨Database£©
ÊÇ´ÅÅÌÉÏ´æ´¢µÄÊý¾ÝµÄ¼¯ºÏ£¨°üÀ¨ÅäÖÃÎļþ¡¢Êý¾ÝÎļþ¡¢ÈÕÖ¾ÎļþºÍ¿ØÖÆÎÄ
¼þµÈ£©
Êý¾Ý¿âʵÀý£¨Database Instance£©
ÔËÐÐÔÚÊý¾Ý¿âÎļþÉϵÄÒ»×éOracleºǫ́½ø³Ì/Ïß³ÌÒÔ¼°Ò»¸ö¹²ÏíÄÚ´æÇø¡£Êý¾Ý
¿â¿ÉÒÔÓÉʵÀý×°ÔØºÍ´ò¿ª¡£
Êý¾Ý¿â·þÎ ......
OracleÔÚÖ´ÐÐÒ»¸öSQL֮ǰ,Ê×ÏÈÒª·ÖÎöÒ»ÏÂÓï¾äµÄÖ´Ðмƻ®,È»ºóÔÙ°´Ö´Ðмƻ®È¥Ö´ÐС£·ÖÎöÓï¾äµÄÖ´Ðмƻ®µÄ¹¤×÷ÊÇÓÉÓÅ»¯Æ÷(Optimizer)À´Íê³ÉµÄ¡£²»Í¬µÄÇé¿ö,Ò»ÌõSQL¿ÉÄÜÓжàÖÖÖ´Ðмƻ®,µ«ÔÚijһʱµã,Ò»¶¨Ö»ÓÐÒ»ÖÖÖ´Ðмƻ®ÊÇ×îÓŵÄ,»¨·Ñʱ¼äÊÇ×îÉٵġ£ÏàÐÅÄãÒ»¶¨»áÓÃPl/sql Developer¡¢ToadµÈ¹¤¾ßÈ¥¿´Ò»¸öÓï¾äµÄÖ´Ðмƻ®,²»¹ýÄã ......
ÎÒÃǶ¼ÖªµÀÔÚOracleÖÐÿÌõSQLÓï¾äÔÚÖ´ÐÐ֮ǰ¶¼ÐèÒª¾¹ý½âÎö£¬ÕâÀïÃæÓÖ·ÖΪÈí½âÎöºÍÓ²½âÎö¡£ÄÇôÕâÁ½ÖÖ½âÎöÓкβ»Í¬Ö®´¦ÄØ£¿ËüÃÇÓÖ·Ö±ðÊÇÈçºÎ½øÐнâÎöÄØ£¿OracleÄÚ²¿½âÎöµÄ²½ÖèÓÖÊÇÈçºÎ½øÐеÄÄØ£¿ÏÂÃæÎÒÃǾÍÕâЩ»°Ìâ½øÐй²Í¬Ì½ÌÖ¡£ ÔÚOracleÖдæÔÚÁ½ÖÖÀàÐ͵ÄSQLÓï¾ä£¬Ò»ÀàΪDDLÓï¾ä£¬ËûÃÇÊÇ´ÓÀ´²»»á¹²ÏíʹÓõģ¬Ò²¾ÍÊÇÿ´ÎÖ´ ......