OracleÒì³£´¦Àí×ܽá
OracleÒì³£´¦Àí×ܽá
ÓÐÓï·¨×ÅÉ«µÄ£¬´ó¼Ò¿ÉÒÔä¯ÀÀÕâ¶ù£ºhttp://www.ouora.com/post/145.html
ΪÁË´¦ÀíPL/SQLÓ¦ÓóÌÐòµÄ¸÷ÖÖ´íÎ󣬿ª·¢ÈËÔ±¿ÉÒÔʹÓø÷ÖÖÀàÐ͵ÄÒì³£¡£
OracleÌṩÁË
£±£ºÔ¤¶¨ÒåÒì³£
ÓÃÓÚ´¦Àí³£¼ûµÄOracle´íÎó
£²£º·ÇÔ¤¶¨ÒåÒì³£
ÓÃÓÚ´¦ÀíÔ¤¶¨ÒåÒì³£Ëù²»ÄÜ´¦ÀíµÄOracle´íÎó
£³£º×Ô¶¨ÒåÒì³£
ÓÃÓÚ´¦ÀíÓÚOracle´íÎóÎ޹صÄÆäËûÇé¿ö
Òì³£´¦Àí²¿·ÖÊÇÒԹؼü×ÖEXCEPTION¿ªÊ¼µÄ£¬Óï·¨ÈçÏ£º
EXCEPTION
WHEN exception_Name THEN --exception_NameΪÒì³£µÄÃû×Ö
statement1;
WHEN OTHERS THEN
statement1;
Òì³£´¦Àí²¿·Ö´Ó¹Ø¼ü×ÖEXCEPTION¿ªÊ¼£¬ÔÚÒì³£´¦Àí²¿·ÖʹÓÃWHEN×־䲶׽¸÷ÖÖÒì³££¬Èç¹ûÓÐÆäËûδԤ¶¨Òåµ½µÄÒì³££¬Ê¹ÓÃWHEN OTHERS THEN×Ö¾ä½øÐв¶×½ºÍ´¦Àí¡£
1¡¢ ´¦ÀíÔ¤¶¨ÒåÒì³££¬ÕâÊÇϵͳԤ¶¨µÄ21ÖÖÀàÐÍ
´íÎó´úÂëÊǸºÕûÊý£¬Èç-51
Access_info_null£¨ora-06530£©
µ±·ÃÎÊûÓгõʼ»¯µÄ¶ÔÏóʱ´¥·¢¡£
Case_not_found(ora-06592)
case¹ý³ÌÖÐwhenºóûÓаüº¬±ØÒªµÄÌõ¼þ·ÖÖ§²¢ÇÒûÓÐelse×Ӿ䣬Ôò»á´¥·¢±¾Òì³£¡£
Collection_is_null(06531)
·ÃÎÊδ³õʼ»¯µÄ¼¯ºÏÔªËØ£¨Ç¶Ì×±í»òÕßvarray£©¡£
Cursor_already_open(ora-06511)
ÖØдò¿ªÒѾ´ò¿ªµÄÓαꡣ
Dup_val_on_index(ora-00001)
µ±ÖÐΨһË÷ÒýËù¶ÔÓ¦µÄÁÐÉϼüÈëÖظ´ÖµÊ±¡£
Invalid_cursor(ora-01001)
ÊÔͼÔÚ²»ºÏ·¨µÄÓαêÉÏÖ´ÐвÙ×÷ʱ£¬Æ©Èçû´ò¿ªÓαê¾ÍÌáÈ¡ÄÚÈÝ
Invalid_number(ora-01722)
µ±ÊÔͼ½«·Ç·¨µÄ×Ö·û´®×ª»»ÎªÊý×ÖÀàÐÍʱ¡£
No_data_found(ora-01403)
Ö´ÐÐselect intoδ·µ»ØÐУ¬»òÕßÒýÓÃÁËË÷Òý±íδ³õʼ»¯µÄÔªËØʱ¡£
Too_many_rows(ora-01422)
Ö´ÐÐselect into·µ»Ø³¬¹ýÒ»ÐÐÊ
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
½ñÌìдÓйØOracleÖк¯ÊýÓë´¥·¢Æ÷µÄÄÚÈÝ£¬ÔÚÊý¾Ý¿âÖж¨Ò岢ʹÓô洢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷£¬¿ÉÒÔÌá¸ßÓû§·ÃÎÊÊý¾Ý¿âµÄЧÂÊ¡£
Êý¾Ý¿âÖк¯Êý°üº¬Ëĸö²¿·Ö£ºÉùÃ÷¡¢·µ»ØÖµ¡¢º¯ÊýÌåºÍÒì³£´¦Àí¡£
1 create or replace function getname(sno varchar2 )
2 &nbs ......
MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......