Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±íÖÐÊÇ·ñ´æÔÚ ¡°ÕÅÈý¡±ÐÕÃûµÄÊý¾Ý£¬Èç¹ûÓС­¡­




Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

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

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

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

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

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ºÅ