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

oracle¼ì²é²åÈëÊý¾ÝµÄSQLÓï¾ä - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÏëÍù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±íÖÐÊÇ·ñ´æÔÚ ¡°ÕÅÈý¡±ÐÕÃûµÄÊý¾Ý£¬Èç¹ûÓС­¡­




Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ 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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ