oracle´æ´¢¹ý³Ì±àдµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
±¾È˸ոսӴ¥´æ´¢¹ý³Ì·½ÃæµÄÉè¼Æ£¬ÔÚ±àдµØ·½²»Ì«¶®¡£ÎÒÏÖÔÚµÄÇé¿öÊÇÕâÑùµÄ£ºÎÒ´´½¨ÁËÒ»¸ö´æ´¢¹ý³Ì×ֶδúÂëÈçÏÂ
(
plateid in Varchar2,
platecolor in Varchar2,
platetype in Varchar2,
crossingtime in Date,
crossingname in Varchar2,
aspectname in Varchar2,
wayname in Varchar2,
speed in Varchar2,
illegaltype in Number,
blackstate in Number,
filepath1 in Varchar2,
filepath2 in Varchar2,
filepath3 in Varchar2,
filepath4 in Varchar2,
result_blackstate out Number£¬
result_plateid out Number
)
as
begin
commit;
end;
ÐèÒª²åÈëÒÔÉÏ×ֶεıíÃûΪ£º
tb_plate;tb_illegalcar;tb_normalcar
ÐèÒª¿¼ÂǵÄÎÊÌ⣺
1£ºplateid,platecolor,platetype£»Õâ3¸ö×Ö¶ÎÒª·ÅÈë±ítb_plate£¬¶øÇÒ±íÀïµÄplateidÓÐÎ¨Ò»Ô¼Êø£¬Èç·¢ÏÖÏàͬÊý¾Ý·µ»Ø1¡£·µ»ØµÄ×Ö¶ÎÊÇresult_plateid¡£
2£ºcrossingtime,crossingname,aspectname,wayname,speed,illegaltype,filepath1,filepath2,filepath3,filepath4£»ÕâЩ×Ö¶ÎҪͬʱ²åÈëµ½tb_illegalcarºÍtb_normalcarÁ½±íµ±ÖвåÈëÕâ2±íµÄÅжÏÌõ¼þÊÇ£ºµ±illegaltype=1ʱ²åÈëµ½tb_normalcar£¬µ±illegaltype=ÆäËûÊý×Öʱ²åÈëµ½tb_illegalcar±íÀï¡£
3£ºÔÚ²Ù×÷2Öл¹ÒªÅжÏblackstateµÄÖµ£¬Èç¹ûblackstate=1ÄÇôµ±Ç°ÐÅÏ¢²åÈëµ½tb_normalcar±íÀblackstate=2ÄÇôµ±Ç°ÐÅÏ¢²åÈëµ½tb_illegalcar£¬blackstate=3ÄÇôÉáÆúÕâÌõÐÅÏ¢¡£
4:2ºÍ3µÄÅжÏÌõ¼þÊDz¢ÁдæÔڵġ£¶¼ÐèҪȥÅжϡ£
ÒòΪ¿¼Âǵĵط½ºÜ¶à£¬ÐèÒªÅжϵÄÒ²ºÜ¶à¡£µ«ÊÇbeginºÍendÖмäÔõôдÎÒ»¹ÊµÔÚ²»Ì«»á¡£Ï£ÍûµÃµ½½â´ð.
Ìõ¼þÅжÏÓï¾ä£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......