[×ªÔØ]Oracle´æ´¢¹ý³Ìѧϰ
´æ´¢¹ý³Ì´´½¨Óï·¨£º
create or replace procedure ´æ´¢¹ý³ÌÃû£¨param1 in type£¬param2 out type£©
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
Select count(*) into ±äÁ¿1 from ±íA whereÁÐÃû=param1£»
If (ÅжÏÌõ¼þ) then
Select ÁÐÃû into ±äÁ¿2 from ±íA whereÁÐÃû=param1£»
Dbms_output¡£Put_line(‘´òÓ¡ÐÅÏ¢’);
Elsif (ÅжÏÌõ¼þ) then
Dbms_output¡£Put_line(‘´òÓ¡ÐÅÏ¢’);
Else
Raise Òì³£Ãû£¨NO_DATA_FOUND£©;
End if;
Exception
When others then
Rollback;
End;
×¢ÒâÊÂÏ
1£¬ ´æ´¢¹ý³Ì²ÎÊý²»´øÈ¡Öµ·¶Î§£¬in±íʾ´«È룬out±íʾÊä³ö
2£¬ ±äÁ¿´øÈ¡Öµ·¶Î§£¬ºóÃæ½Ó·ÖºÅ
3£¬ ÔÚÅжÏÓï¾äǰ×îºÃÏÈÓÃcount£¨*£©º¯ÊýÅжÏÊÇ·ñ´æÔÚ¸ÃÌõ²Ù×÷¼Ç¼
4£¬ ÓÃselect ¡£¡£¡£into¡£¡£¡£¸ø±äÁ¿¸³Öµ
5£¬ ÔÚ´úÂëÖÐÅ×Òì³£Óà raise+Òì³£Ãû
ÒÔÃüÃûµÄÒì³£
ÃüÃûµÄϵͳÒì³£ ²úÉúÔÒò
ACCESS_INTO_NULL 䶨Òå¶ÔÏó
CASE_NOT_FOUND CASE ÖÐÈôδ°üº¬ÏàÓ¦µÄ WHEN £¬²¢ÇÒûÓÐÉèÖÃ
ELSE ʱ
COLLECTION_IS_NULL ¼¯ºÏÔªËØÎ´³õʼ»¯
CURSER_ALREADY_OPEN ÓαêÒѾ´ò¿ª
DUP_VAL_ON_INDEX ΨһË÷Òý¶ÔÓ¦µÄÁÐÉÏÓÐÖØ¸´µÄÖµ
INVALID_CURSOR
Ïà¹ØÎĵµ£º
DBMS_CHANGE_NOTIFICATION
¶ÔÏó£¨±í£©Êý¾Ý¸üÐÂ֪ͨ
DBMS_APPLICATION_INFO
ÉèÖÃ/¶ÁÈ¡SESSION APPLICATIONÐÅÏ¢£¬²Ù×÷V$SESSION_LONGOPS
DBMS_ALERT
¸æ¾¯
DBMS_DATAPUMP
Êý¾ÝÇ¨ÒÆ
DBMS_DB_VERSION
Êý¾Ý¿â°æ±¾¶¨Òå
DBMS_DDL
Compiles¡¢wrapped¡¢Reorganizes ¶ÔÏó
DBMS_DEBUG
ORACLE DEPL/SQL debugger ¹¤¾ß
DB ......
°²×°×¼±¸£º
ÏÂÔØÎļþ
l Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ· ......
Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊǰ´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
ÈçÏÂͼËùʾ£¬ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°üÀ¨<Ö÷¼üÁÐÖµ£¬·ÇÖ÷¼üÁÐÖµ>¶ø ......
×î½ü¿ÕÏÐʱ¼ä½Ï¶à£¬¿ªÊ¼Ñ§Ï°OracleÊý¾Ý¿â֪ʶ¡£ÏÂÎÄÊǶÔOracleÊý¾Ý¿âÏà¹Ø¸ÅÄîµÄһЩ±Ê¼Ç¡£
³õѧOracle£¬Àí½âOracleʵÀý¡¢OracleÊý¾Ý¿âºÍOracle·þÎñÆ÷µÈÃû´ÊÊõÓïÊǺÜÖØÒªµÄ¡£
ÊõÓï½âÊÍ:
OracleʵÀý/OracleÊý¾Ý¿â
Ò»°ãOracleÊý¾Ý¿â(Oracle Database)¿ÉÒÔ·ÖΪÁ½²¿ ......