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

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µÄÐÅÏ¢£¬Ä㵱ǰÓû§ÎÞ·¨²é¿´¶øÒÑ¡£ ÄãµÄµ±Ç°Óû§¶¼ÓÐʲôȨÏÞѽ¡£

ÒýÓÃ
Ó¦¸ÃûÓÐÓ°Ïì°É£¬ÕâÀïÓ¦¸ÃÊÇһЩstatisticsµÄÐÅÏ¢£¬Ä㵱ǰÓû§ÎÞ·¨²é¿´¶øÒÑ¡£ ÄãµÄµ±Ç°Óû§¶¼ÓÐʲôȨÏÞѽ¡£


ºóÃæµÄ²Ù×÷µ¹ÊÇ¿ÉÒԵģ¨ËäÈ»ÎÒ²»ÖªµÀÒÔºó»á²»»áÓÐÒþ»¼£©

µ«ÊÇÕâ¸ö±íÊÇÓÉÎÒÕâ¸öÕ˺Å×Ô¼º½¨µÄ°¡

Ó¦¸ÃÓÐËùÓÐȨÏÞ°¡


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«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Êý¾Ý¿â±íÄÜ×Ô¶¯É¾³ýÐÐÂð£¿

ÎÒÓÃsql serverÊý¾Ý±í´æ·ÅһЩÐÅÏ¢£¬·¢ÏÖÊý¾Ý¿âÔö¼ÓËٶȺܿ졣

ÄÜ·ñÉèÖñíµÄ´óСºó£¬ÈÃËü×Ô¶¯É¾³ý×îÏȵÄÊý¾Ý¡£

ÀýÈçÉèÖñíÈÝÁ¿Îª10000ÐУ¬Ïñ¶ÓÁÐÒ»Ñù£¬Èç¹ûÓÐÐÂÊý¾Ý½øÀ´£¬¾Íɾ³ýµô×îÏȵÄÊý¾Ý¡£

......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ