PL/SQL ¿éµÄѧϰ£¨¾«»ª£©
PL/SQL¿é
declare
begin
--SQLÓï¾ä
--Ö±½ÓдµÄSQLÓï¾ä(DML/TCL)
--¼ä½Óдexecute immediate <DDL/DCLÃüÁî×Ö·û´®>
--select Óï¾ä
<1>±ØÐë´øÓÐinto×Ó¾ä
select empno into eno from emp
where empno =7369;
<2>Ö»Äܲ鵽һÐÐ**********
<3>×ֶθöÊý±ØÐëºÍ±äÁ¿µÄ¸öÊýÒ»ÖÂ
exception
--Òì³£
when <Òì³£Ãû×Ö> then --ÌØ¶¨Òì³£
<´¦ÀíÓï¾ä>
when others then --ËùÓÐÒì³£¶¼¿É²¶»ñ
<´¦ÀíÓï¾ä>
end;
<Àý×Ó>
±àд³ÌÐò ÏòDEPT±íÖвåÈëÒ»Ìõ¼Ç¼£¬
´Ó¼üÅÌÊäÈëÊý¾Ý£¬Èç¹û
Êý¾ÝÀàÐÍÊäÈë´íÎóÒªÓÐÌáʾ
ÎÞ·¨²åÈë¼Ç¼ Ò²ÒªÓÐÌáʾ
Ö»ÄÜÊäÈëÕýÊý,Èç¹ûÓиºÊýÌáʾ
declare
n number;
no dept.deptno%type;
nm dept.dname%type;
lc dept.loc%type;
exp exception; --Òì³£µÄ±äÁ¿
exp1 exception;
num number:=0; --¼ÆÊýÆ÷
pragma exception_init(exp,-1); --Ô¤¶¨ÒåÓï¾ä
--(-1´íÎóºÍÒì³£±äÁ¿¹ØÁª)
pragma exception_init(exp1,-1476);
e1 exception; --×Ô¶¨ÒåÒì³£±äÁ¿
begin
--ÊäÈëÖµ
no := '&񅧏';
num := num + 1;
if no < 0 then
raise e1; --×Ô¶¨ÒåÒì³£µ
Ïà¹ØÎĵµ£º
LINQ to SQL ÐÔÄÜ 10 Tips
http://www.cnblogs.com/worksguo/archive/2008/06/04/1213075.html
ǰһÖÜ£¬ÎÒµÄÓ²ÅÌÓÐÁ½·ÖÇø»µÁË£¬ÎÒ×¼±¸µÄÎÄÕÂÓë×ÊÁ϶¼ÔÚÀïÃæ£¬ËùÒÔLINQµÄÎÄÕÂÍ£ÁËÒ»¶Îʱ¼ä£¬ÕæµÄÌ«²»ºÃÀ£¬ÎªÀ´ÃÖ²¹Ò»Ï¾ÍÏÈ·¢ÕâÆªÎÄÕÂÉÏÀ£¬Ã÷ÌìÔÙһƪ¹ØÓÚDisconnection DataµÄÎÄÕ¡£
Ö»²»¹ýÐҺã¬ÔÚÕ⼸ÌìÖÐÎҽ߾¡È«Á¦ ......
Éè¼ÆÔÔò
·ûºÅÈý´ó·¶Ê½£¨Ã¿Ò»Áбí´ïÒ»¸öÒâ˼£¬Ã¿Ò»Ðдú±íÒ»¸öʵÀý/ÿһÐÐÓÐΨһ¼ü/±íÄÚûÓÐÆäËü±íµÄ·ÇÖ÷¼üÐÅÏ¢£©
ÿ¸ö±íÓ¦¸ÃÓеÄ3¸öÓÐÓÃ×ֶΣ¨¼Ç¼´´½¨»ò¸üÐÂʱ¼ä/¼Ç¼´´½¨Õß/¼Ç¼°æ±¾£©
±ÜÃâ±£Áô×Ö
±íÓ¦±ÜÃâ¿ÉΪ¿ÕµÄÁÐ
ÃüÃû¹æ·¶
±í
±íÃûÈçOr ......
ÕªÒª£º±¾ÎĽéÉÜÁËÔÚ¿Í»§»úÉÏ´¦Àí Microsoft sql server(WINDOWSƽ̨ÉÏÇ¿´óµÄÊý¾Ý¿âƽ̨) ²éѯµÄ·½Ê½£¬¸÷ÖÖ¿Í»§»úÓë sql server(WINDOWSƽ̨ÉÏÇ¿´óµÄÊý¾Ý¿âƽ̨) µÄ½»»¥·½Ê½£¬ÒÔ¼° sql server(WINDOWSƽ̨ÉÏÇ¿´óµÄÊý¾Ý¿âƽ̨) ÔÚ´¦Àí¿Í»§»ú³ÌÐòµÄÇëÇóʱÐèÒªÍê³ÉµÄ¹¤×÷¡£
¼ò½é
¡¡¡¡Microsoft(R) sql server(WINDOWSƽ̨ÉÏÇ¿ ......