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

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ÊÇÊä³ö£¬µ±ÄãµÄ¹ý³ÌÀïÓÐÊä³öʱ¾ÍÓÐÏÔʾ£¬±ÈÈç
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#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

Ò»µÀsql±ÊÊÔÌâ

Table bidrank(vendorcode char(10),price money,submittime datetime,rank int)ÊÇÒ»¸öÓÃÀ´±£´æ¹©Ó¦É̱¨¼Û×ÊÁÏµÄ±í£¬
ÆäÖÐvendorcode:Êǹ©Ó¦ÉÌ´úÂë
price£ºÎª±¨¼Û
rank£ºÎª¹©Ó¦É̱¨¼ÛÅÅÃû

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