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µÄÐÅÏ¢£¬Ä㵱ǰÓû§ÎÞ·¨²é¿´¶øÒÑ¡£ ÄãµÄµ±Ç°Óû§¶¼ÓÐʲôȨÏÞѽ¡£
ºóÃæµÄ²Ù×÷µ¹ÊÇ¿ÉÒԵģ¨ËäÈ»ÎÒ²»ÖªµÀÒÔºó»á²»»áÓÐÒþ»¼£©
µ«ÊÇÕâ¸ö±íÊÇÓÉÎÒÕâ¸öÕ˺Å×Ô¼º½¨µÄ°¡
Ó¦¸ÃÓÐËùÓÐȨÏÞ°¡
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´
ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)
SQL ......
±í A
sup_code // ÔÚ¿â
part_id // ÐͺÅ
buy_sup_id &nbs ......