ÎÒÏëÍùoracle±íÖвåÈëÊý¾Ý£¬ÓиöÎÊÌâÀ§ÈÅÎҺþÃÁË£¬Ï£ÍûµÃµ½´óϺµÄ°ïÖú£¡£¡£¡ÒÔÏÂÊÇÎÊÌâÃèÊö£º
ÎÒÏë×öÓÃSQLÓï¾äÅÐ¶Ï a±íÖÐ ÊÇ·ñÓиÃÊý¾Ý£¬Èç¹ûûÓоÍÔö¼Ó£¬Èç¹ûÓоͲ»Ôö¼Ó¡£
¹Ø×¢¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
oracle ÓÃplsqlʵÏÖÊý¾Ý£¬Èç¹ûûÓоÍÔö¼Ó£¬Èç¹ûÓоͲ»Ôö¼Ó
2Â¥µÄ»Ø¸´ Ö»»Ø´ðÎÒÒ»¸öÐèÇó£¬ÎÒ»¹ÓÐÒ»¸öÐèÇó¾ÍÊÇ˵£º±ÈÈçÒ»ÕÅA±í£¬ÆäÖÐÓÐÐÕÃû¡¢ÄêÁä2¸ö×ֶΣ¬ÎÒÒª¼ì²éA±íÖÐÊÇ·ñ´æÔÚ ¡°ÕÅÈý¡±ÐÕÃûµÄÊý¾Ý£¬Èç¹ûÓУ¬ÎҾͲ»ÔÙÔö¼Ó£¬Èç¹ûûÓУ¬ÎÒ¾ÍÔö¼ÓÐÕÃûΪ¡°ÕÅÈý¡±µÄÊý¾Ý¡£
ÒýÓà insert into a select 'xx','xx','xx' from dual where not exists( select 1 from a where a.xx='xx')2Â¥µÄ»Ø¸´ Ö»»Ø´ðÎÒÒ»¸öÐèÇó£¬ÎÒ»¹ÓÐÒ»¸öÐèÇó¾ÍÊÇ˵£º±ÈÈçÒ»ÕÅA±í£¬ÆäÖÐÓÐÐÕÃû¡¢ÄêÁä2¸ö×ֶΣ¬ÎÒÒª¼ì²éA±íÖÐÊÇ·ñ´æÔÚ ¡°ÕÅÈý¡±ÐÕÃûµÄÊý¾Ý£¬Èç¹ûÓУ¬ÎҾͲ»ÔÙÔö¼Ó£¬Èç¹ûûÓУ¬ÎÒ¾ÍÔö¼ÓÐÕÃûΪ¡°ÕÅÈý¡±µÄÊý¾Ý¡£
declare
iCount number;
begin
select count(1) into iCount from t1;
if iCount=0 then
insert into t1 select null from dual;
end if;
end;
ÒýÓà ÒýÓà 2 Â¥ wildwave µÄ»Ø¸´: insert into a select 'xx','xx','xx' from dual where not exists( select 1 from a where a.xx='xx') 2Â¥µÄ»Ø¸´ Ö»»Ø´ðÎÒÒ»¸öÐèÇó£¬ÎÒ»¹ÓÐÒ»¸öÐèÇó¾ÍÊÇ˵£º±ÈÈçÒ»ÕÅA±í£¬ÆäÖÐÓÐÐÕÃû¡¢ÄêÁä2¸ö×ֶΣ¬ÎÒÒª¼ì²éA±íÖÐÊÇ·ñ´æÔÚ ¡°ÕÅÈý¡±ÐÕÃûµÄÊý¾Ý£¬Èç¹ûÓС¡
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......