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




Ïà¹ØÎÊ´ð£º

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

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

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

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ