ÎÒÏëÍù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±íÖÐÊÇ·ñ´æÔÚ ¡°ÕÅÈý¡±ÐÕÃûµÄÊý¾Ý£¬Èç¹ûÓС¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......
ÐèÇóÈçÏ£º ѧԺ 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 ......