Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

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

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

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ