PL/SQLÎÊÌâ
PL/SQLÀïÃæµÄTABLE---¡·QUERY½çÃæ
ÓÐSQL|OUTPUT|STATISTICSÈý¸öÒ³Ãæ
ΪʲôÎÒÔÚSQLÀïÃæÓÃSELECTÓï¾ä»òÕßUPDATEºó£¬OUTPUTºÍSTATISTICSÒ³Ãæ¶¼Ã»ÈκÎÊý¾Ý£¿
ÊÇҪʲôÇé¿öÏ£¬Õâ2¸öÒ³ÃæÒ²»áÓÐÊý¾ÝÏÔʾ£¿
UP
OUTPUTÊÇÊä³ö£¬µ±ÄãµÄ¹ý³ÌÀïÓÐÊä³öʱ¾ÍÓÐÏÔʾ£¬±ÈÈç
begin
dbms_out.put_line('haha');
end;
ÔÚOUTPUT¾Í»áÏÔʾhaha»¹Óиö»»ÐС£
STATISTICSÊÇÓÃÀ´¼à¿ØSQLµÄ£¬Ö»ÒªORACLE´ò¿ªÁË¼à¿Ø£¬Ã¿´ÎÖ´ÐÐSQL¶¼»áÓÐÊý¾ÝÏÔʾÈç¶ÁÈ¡¼Ç¼Êý£¬²éѯµÄBLOCKÊýÁ¿µÈµÈ¡£
Ŷ£¬¶àл¥ÉϵÄ
OUTPUTÊÇ¿ÉÒÔÊä³öÁË
ORACLEµÄ¼à¿ØÊÇÔõô´ò¿ªµÄ£¿
ORACLEµÄ¼à¿ØÊÇÔõô´ò¿ªµÄ£¿
End_rbody_60313263//-->
¸Ã»Ø¸´ÓÚ2009-10-11 08:58:01±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
Table bidrank(vendorcode char(10),price money,submittime datetime,rank int)ÊÇÒ»¸öÓÃÀ´±£´æ¹©Ó¦É̱¨¼Û×ÊÁÏµÄ±í£¬
ÆäÖÐvendorcode:Êǹ©Ó¦ÉÌ´úÂë
price£ºÎª±¨¼Û
rank£ºÎª¹©Ó¦É̱¨¼ÛÅÅÃû
ÎÊÌ⣺ÏÂà ......