PL/SQLÌø³öµÄ´íÎó
ÎÒÔÚPL/SQLÀïÃæµã»÷¡°±í¡±£¬ÔÚÓÒ¼üÑ¡Ôñ¡°QUERY¡±
Ìø³öÈçÏ´íÎó£º
ERROR
Dynamic Performance Tables not accessible,
Automatic Statistics disabled fro this session
You can disable statistics in the preference menu,or obtain select
priviliges on the v$sesstat and v$statname tables
ÕâÊÇʲô´íÎó£¿
Ó¦¸ÃûÓÐÓ°Ïì°É£¬ÕâÀïÓ¦¸ÃÊÇһЩstatisticsµÄÐÅÏ¢£¬Ä㵱ǰÓû§ÎÞ·¨²é¿´¶øÒÑ¡£ ÄãµÄµ±Ç°Óû§¶¼ÓÐʲôȨÏÞѽ¡£
ºóÃæµÄ²Ù×÷µ¹ÊÇ¿ÉÒԵģ¨ËäÈ»ÎÒ²»ÖªµÀÒÔºó»á²»»áÓÐÒþ»¼£©
µ«ÊÇÕâ¸ö±íÊÇÓÉÎÒÕâ¸öÕ˺Å×Ô¼º½¨µÄ°¡
Ó¦¸ÃÓÐËùÓÐȨÏÞ°¡
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´
ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)
SQL ......
ÎÒÓÃsql serverÊý¾Ý±í´æ·ÅһЩÐÅÏ¢£¬·¢ÏÖÊý¾Ý¿âÔö¼ÓËٶȺܿ졣
ÄÜ·ñÉèÖñíµÄ´óСºó£¬ÈÃËü×Ô¶¯É¾³ý×îÏȵÄÊý¾Ý¡£
ÀýÈçÉèÖñíÈÝÁ¿Îª10000ÐУ¬Ïñ¶ÓÁÐÒ»Ñù£¬Èç¹ûÓÐÐÂÊý¾Ý½øÀ´£¬¾Íɾ³ýµô×îÏȵÄÊý¾Ý¡£
......