Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ°²×°ÁËoracle 10g¾­¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ