SQL begin end ¿é×÷ÓÃ
PL/SQL´æ´¢¹ý³Ì±à³Ì ÊÕ²Ø
/**author huangchaobiao
*Email:huangchaobiao111@163.com
*/
PL/SQL´æ´¢¹ý³Ì±à³Ì(ÉÏ)
1. OracleÓ¦Óñ༷½·¨¸ÅÀÀ
´ð£º1) Pro*C/C++/... : CÓïÑÔºÍÊý¾Ý¿â´ò½»µÀµÄ·½·¨£¬±ÈOCI¸ü³£ÓÃ;
2) ODBC
3) OCI: CÓïÑÔºÍÊý¾Ý¿â´ò½»µÀµÄ·½·¨£¬ºÍProCºÜÏàËÆ£¬¸üµ×²ã£¬ºÜÉÙÓÃ;
4) SQLJ: ºÜеÄÒ»ÖÖÓÃJava·ÃÎÊOracleÊý¾Ý¿âµÄ·½·¨£¬»áµÄÈ˲»¶à;
5) JDBC
6) PL/SQL: ´æ´¢ÔÚÊý¾ÝÄÚÔËÐÐ, ÆäËû·½·¨ÎªÔÚÊý¾Ý¿âÍâ¶ÔÊý¾Ý¿â·ÃÎÊ;
2. PL/SQL
´ð£º1) PL/SQL(Procedual language/SQL)ÊÇÔÚ±ê×¼SQLµÄ»ù´¡ÉÏÔö¼ÓÁ˹ý³Ì»¯´¦ÀíµÄÓïÑÔ;
2) Oracle¿Í»§¶Ë¹¤¾ß·ÃÎÊOracle·þÎñÆ÷µÄ²Ù×÷ÓïÑÔ;
3) Oracle¶ÔSQLµÄÀ©³ä;
4. PL/SQLµÄÓÅȱµã
´ð£ºÓŵ㣺
1) ½á¹¹»¯Ä£¿é»¯±à³Ì£¬²»ÊÇÃæÏò¶ÔÏó;
2) Á¼ºÃµÄ¿ÉÒÆÖ²ÐÔ(²»¹ÜOracleÔËÐÐÔÚºÎÖÖ²Ù×÷ϵͳ);
3) Á¼ºÃµÄ¿Éά»¤ÐÔ(±àÒëͨ¹ýºó´æ´¢ÔÚÊý¾Ý¿âÀï);
4) ÌáÉýϵͳÐÔÄÜ;
ȱµã
1) ²»±ãÓÚÏòÒì¹¹Êý¾Ý¿âÒÆÖ²Ó¦ÓóÌÐò(Ö»ÄÜÓÃÓÚOracle);
5. SQLÓëPL/SQLµÄÇø±ð
´ð£ºSQL£º1) µÚËÄ´úÓïÑÔ(ÖÇÄÜÓïÑÔ);
2) ×öʲô£¬²»¹ÜÔõô×ö;
3) ȱÉÙ¹ý³ÌÓë¿ØÖÆÓï¾ä;
4) ÎÞËã·¨
PL/SQL: 1) À©Õ¹±äÁ¿ºÍÀàÐÍ;
2) À©Õ¹¿ØÖƽṹ;
3) À©Õ¹¹ý³ÌÓ뺯Êý;
4) À©Õ¹¶ÔÏóÀàÐÍÓë·½·¨
µÚ¶þÕÂ
PL/SQL³ÌÐò½á¹¹
1. PL/SQL¿é
´ð£º1) ÉêÃ÷²¿·Ö, DECLARE(²»¿ÉÉÙ);
2) Ö´Ðв¿·Ö, BEGIN...END;
3) Òì³£´¦Àí£¬EXCEPTION(¿ÉÒÔûÓÐ);
2. PL/SQL¿ª·¢»·¾³
´ð£º¿ÉÒÔÔËÓÃÈκδ¿Îı¾µÄ±à¼Æ÷±à¼£¬ÀýÈ磺VI
3. PL/SQL×Ö·û¼¯
´ð£ºPL/SQL¶Ô´óСд²»Ãô¸Ð
4. ±êʶ·ûÃüÃû¹æÔò
´ð£º1) ×Öĸ¿ªÍ·;
2) ºó¸úÈÎÒâµÄ·Ç¿Õ¸ñ×Ö·û¡¢Êý×Ö¡¢»õ±Ò·ûºÅ¡¢Ï»®Ïß¡¢»ò# ;
3) ×î´ó³¤¶ÈΪ30¸ö×Ö·û(°Ë¸ö×Ö·û×óÓÒ×îºÏÊÊ);
5. ±äÁ¿ÉùÃ÷
´ð£ºÓï·¨
Var_name type [CONSTANT][NOT NULL][:=value];
×¢£º1) ÉêÃ÷ʱ¿ÉÒÔÓÐĬÈÏÖµÒ²¿ÉÒÔûÓÐ;
2) ÈçÓÐ[CONSTANT][NOT NULL], ±äÁ¿Ò»¶¨ÒªÓÐÒ»¸ö³õʼֵ;
3) ¸³ÖµÓï¾äΪ“:=”;
4) ±äÁ¿¿ÉÒÔÈÏΪÊÇÊý¾Ý¿âÀïÒ»¸ö×Ö¶Î;
5) ¹æ¶¨Ã»Óгõʼ»¯µÄ±äÁ¿ÎªNULL;
µÚÈýÕÂ
1. Êý¾ÝÀàÐÍ
´ð£º1) ±êÁ¿ÐÍ£ºÊý×ÖÐÍ¡¢×Ö·ûÐÍ¡¢²¼¶ûÐÍ¡¢ÈÕÆÚÐÍ;
2) ×éºÏÐÍ£ºRECORD(³£ÓÃ)¡¢TABLE(³£ÓÃ)¡¢VARRAY(½ÏÉÙÓÃ)
3) ²Î¿¼ÐÍ£ºREF CURSOR(Óαê)¡¢REF object_type
4) LOB(Large Object)
2. %TYPE
´ð£º±äÁ¿¾ßÓÐÓëÊý¾Ý¿âµÄ±íÖÐijһ×Ö¶ÎÏàͬµÄÀàÐÍ
Àý£ºv_FirstName studengt
Ïà¹ØÎĵµ£º
Ò»¡¢ SQL DMO ÃèÊö£ºSQL Distributed Management Objects£¨SQL·Ö²¼Ê½¹ÜÀí¶ÔÏ󣩣¬´æÔÚÓÚSQLDMO.dllÎļþÖУ¬Êµ¼ÊÉÏÊÇÒ»¸öCOM ¶ÔÏó£¬Í¨¹ýµ÷ÓÃSQL DMOµÄListAvailableSQLServers·½·¨È¡µÃ¡£ ÁбíÀàÐÍ£ºÁоÙ×°ÓС°¿Í»§¶Ë¡±ºÍ¡°·þÎñ¶Ë¡±µÄ¼ÆËã»ú¡£ ÊÊÓÃÌõ¼þ£º×°ÓÐ SQL Server£¬ÇÒÓÐSQLDMO.dllÎļþ¡£ ËٶȣºÖÐ µ÷ÓÃʾÀý£ºGetS ......
1.¼à¿Øµ±Ç°Êý¾Ý¿âËÔÚÔËÐÐʲôSQLÓï¾ä
SELECT osuser, username, sql_text from v$session a, v$sqltext b
where a.sql_address =b.address order by address, piece;
2.·ÖÎö±í
analyze table tablename compute statistics for all indexes;
analyze table tablename compute statistics for all indexed col ......
×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈË°¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......
ÎÊÌâÀ´×Ôhttp://topic.csdn.net/u/20091128/10/6750afae-71df-42df-ae23-14024736e1d8.html?64174
ÒÀÎҲ²â¿ÉÄÜÊÇҪƴ×Ö¶ÎÃû³Æ
if (D > 0)
{
UpData_D = "D_D" + D.ToString();
DataSet myData = Socut.Data.ExecuteDataSet("UPDATE YUAN SET " + UpData_D + "='" + Y + "',..........
}
......
SQL server°²×°Ê±Ê±£º“ÒÔÇ°µÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú”´íÎó¡£
´ò¿ª×¢²á±í±à¼Æ÷£¨¿ªÊ¼->ÔËÐÐ->regedit£©£¬ÔÚHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session ManagerÖÐÕÒµ½PendingFileRenameOperationsÏîÄ¿£¬²¢É¾³ýËü¡£ÕâÑù ......