±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 618  |  »Ø¸´: 1

renyan198251

ľ³æ (СÓÐÃûÆø)


[½»Á÷] ¡¾ÇóÖú¡¿Çó±à³Ì

Ò»¸öͼÊéÏúÊÛÊý¾Ý¿â BookShopDB£¬
ÀïÃæÓÐͼÊéÐÅÏ¢BookInfo±í(BookID,BookName,Author,ISBN,PublishDate,PublisherID,CategoryID,Price,Content)¡¢Í¼ÊéÀà±ð±íCategory£¨CategoryID,CategoryName£©¡¢³ö°æÉç±íPublisher£¨PublisherID,PublisherName£©¡¢ÏúÊÛÃ÷ϸ±íSales(SalesID,BookID,Quantity,SalesDate,Discount,Price,SalesPrice,Userid)¡¢Óû§±íUserinfo(UserID,UserName,Sex)
Çó±àдһ¸öSQLÓïÑÔ£º¡°Éè¼ÆÒ»¸ö´æ´¢¹ý³Ì£¬²ÉÓÃÄ£ºý²éѯ·½Ê½²éÕÒÖ¸¶¨³ö°æÉçÊé¼®ÐÅÏ¢¡±
лл£¡
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

» ÇÀ½ð±ÒÀ²£¡»ØÌû¾Í¿ÉÒԵõ½:

²é¿´È«²¿É¢½ðÌù

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

xqwbx163

Òø³æ (СÓÐÃûÆø)


¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
renyan198251(½ð±Ò+10): ¶àлÁË¡£ 2011-04-28 17:33:14
ÕâÊÇд´æ´¢¹ý³ÌµÄÒ»¸öÀý×Ó£¬Äã¿ÉÒÔ·ÂÔìÕâ¸öдд
create or replace procedure p_score799
is
Cursor cursor1 is select score_code,busi_code,op_cfg,income_cfg,begin_ymd,end_ymd,score_type from temp799;
score_code1 varchar2(8);
busi_code1 varchar2(64);
  op_cfg1 NUMBER(12,2);
  income_cfg1 NUMBER(18,8);
i NUMBER(4);
p_SiteID number(10);
begin_ymd1 varchar2(125);
end_ymd1 varchar2(125);
score_type1 varchar2(4);
begin
open cursor1;
loop
fetch cursor1 into score_code1,busi_code1,op_cfg1,income_cfg1,begin_ymd1,end_ymd1,score_type1;
select count(*) INTO i FROM cScoreCodeCfg t WHERE t.region_code = '799' and t.busi_code=busi_code1;
            IF i=0 THEN


begin
exit when cursor1%notfound;
select opacceptid.Nextval INTO p_SiteID from dual;

insert into cScoreCodeCfg(region_code,score_type,score_code,busi_code,op_cfg,income_cfg,begin_ymd,end_ymd,login_id,op_accept,op_time) values('799',score_type1,score_code1,busi_code1,op_cfg1,income_cfg1,begin_ymd1,end_ymd1,'10000848',p_SiteID,'2010-09-06 15:11:55');
commit;
end;
else
exit when cursor1%notfound;
END IF;


end LOOP;
close cursor1;

end p_score799;
2Â¥2011-04-28 17:13:33
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ renyan198251 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸Ö£ÖÝ´óѧ²ÄÁÏÓ뻯¹¤×¨Ë¶£¬Ó¢¶þÊý¶þ342·Ö£¬ÇóÀÏʦÊÕÁô +17 v12abo 2026-04-02 18/900 2026-04-03 16:38 by lijunpoly
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤306·ÖÕÒµ÷¼Á +22 ²×º£ÇáÖÛe 2026-04-02 23/1150 2026-04-03 15:08 by hypershenger
[¿¼ÑÐ] 280Çóµ÷¼Á +17 ¹¾ààÏþÏþ 2026-04-02 18/900 2026-04-03 15:03 by hypershenger
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©¿Æ¼¼´óѧ²ÄÁϹ¤³Ì085601£¬Çóµ÷¼Á +13 cdyw 2026-04-02 13/650 2026-04-03 14:51 by lsÁõ˧
[¿¼ÑÐ] Ò»Ö¾Ô¸ÉúÎïÓëÒ½Ò©£¬296·Ö£¬Çóµ÷¼Á +8 66¹ 2026-04-03 9/450 2026-04-03 14:22 by »¯Ñ§»¯¹¤Ë¶Ê¿ÕÐÉ
[¿¼ÑÐ] 085600ר˶²ÄÁÏÓ뻯¹¤348·ÖÇóµ÷¼Á +10 ÉÏѧÀ²£¡ 2026-04-01 11/550 2026-04-03 14:13 by °ÙÁéͯ888
[¿¼ÑÐ] 321Çóµ÷¼Á +17 y-yh 2026-04-01 20/1000 2026-04-03 12:57 by y-yh
[¿¼ÑÐ] »¯Ñ§070300-×Ü·Ö378-Çóµ÷¼Á +5 ŲÒÎ×ÓµÄÅÝÅÝÌÇ 2026-04-02 5/250 2026-04-02 22:20 by ZXlzxl0425
[¿¼ÑÐ] ¡£ +4 ÎíÓ뺣 2026-04-02 5/250 2026-04-02 19:16 by ÍÁľ˶ʿÕÐÉú
[¿¼ÑÐ] 413Çóµ÷¼Á +3 ¿Âijij 2026-03-31 3/150 2026-04-02 16:59 by zzsw+
[¿¼ÑÐ] Ò»Ö¾Ô¸Ö£´ó²ÄÁϹ¤³Ì290Çóµ÷¼Á +20 Youth_ 2026-03-30 20/1000 2026-04-02 14:48 by 5896
[¿¼ÑÐ] 385·Ö ÉúÎïѧ£¨071000£©Çóµ÷¼Á +6 qf626 2026-04-01 6/300 2026-04-02 10:39 by guoweigw
[¿¼ÑÐ] 311Çóµ÷¼Á +16 zchqwer 2026-04-01 18/900 2026-04-02 10:15 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] 279Çóµ÷¼Á +6 ѧ¶øË¼ÙâÖª 2026-04-01 6/300 2026-04-02 09:16 by vgtyfty
[¿¼ÑÐ] ¿¼Ñе÷¼Á +12 Amber00 2026-03-31 12/600 2026-04-02 09:04 by sanrepian
[¿¼ÑÐ] Ò»Ö¾Ô¸°²»Õ´óѧ¼ÆËã»ú¿ÆÑ§Óë¼¼Êõѧ˶£¬331·ÖÇóµ÷¼Á +5 ½¯²ýÅôqtj 2026-04-01 5/250 2026-04-02 08:10 by fxue1114
[¿¼ÑÐ] 302Çóµ÷¼ÁÒ»Ö¾Ô¸±±º½070300£¬±¾¿ÆÖ£´ó»¯Ñ§ +8 Ê¥ÈÕ¶úÂüÌõ 2026-04-01 11/550 2026-04-02 07:40 by chemdavid
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +14 Ò»ÑùYWY 2026-04-01 14/700 2026-04-01 21:07 by lijunpoly
[¿¼ÑÐ] 0703Çóµ÷¼Á +4 zizimo 2026-03-31 4/200 2026-04-01 16:04 by yanflower7133
[¿¼ÑÐ] Ò»Ö¾Ô¸±±½»²ÄÁϹ¤³Ì×Ü·Ö358 +5 cs0106 2026-04-01 7/350 2026-04-01 11:45 by wangjy2002
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û