| ²é¿´: 617 | »Ø¸´: 1 | |||
[½»Á÷]
¡¾ÇóÖú¡¿Çó±à³Ì
|
|
Ò»¸öͼÊéÏúÊÛÊý¾Ý¿â 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ÓïÑÔ£º¡°Éè¼ÆÒ»¸ö´æ´¢¹ý³Ì£¬²ÉÓÃÄ£ºý²éѯ·½Ê½²éÕÒÖ¸¶¨³ö°æÉçÊé¼®ÐÅÏ¢¡± лл£¡ |
» ²ÂÄãϲ»¶
0856£¬269·ÖÇóµ÷¼Á
ÒѾÓÐ18È˻ظ´
292Çóµ÷¼Á
ÒѾÓÐ19È˻ظ´
085601£¬Ò»Ö¾Ô¸Ïôó334¸´ÊÔ±»Ë¢Çóµ÷¼Á
ÒѾÓÐ10È˻ظ´
ÉúÎïѧ308·ÖÇóµ÷¼Á£¨Ò»Ö¾Ô¸»ª¶«Ê¦´ó£©
ÒѾÓÐ7È˻ظ´
ѧ˶»úе¹¤³Ì303Çóµ÷¼Á
ÒѾÓÐ7È˻ظ´
338Çóµ÷¼Á
ÒѾÓÐ7È˻ظ´
285Çóµ÷¼Á
ÒѾÓÐ5È˻ظ´
µ÷¼Á
ÒѾÓÐ4È˻ظ´
²ÄÁÏר˶µ÷¼Á
ÒѾÓÐ18È˻ظ´
348·Ö»·¾³¹¤³Ì¡¤µ÷¼Á
ÒѾÓÐ3È˻ظ´
» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:
Çómathematica±à³Ì
ÒѾÓÐ6È˻ظ´
Çó°ï棬¹ØÓÚº¬ÓÐbesselº¯ÊýµÄ·½³ÌµÄ±à³ÌÇó½âÎÊÌâ
ÒѾÓÐ11È˻ظ´
ÓÐÈý¸ö¼ÆËãÎïÀíµÄÌ⣬´ó¼ÒËÄܰï°ïæ°¡£¬ÒªÇó±à³ÌÐò¡£ÎÒŪÁ˺ü¸ÌìÁË£¬Åª²»³öÀ´£¬¿ÒÇë
ÒѾÓÐ18È˻ظ´
ÇóÖúmatlab±à³Ì
ÒѾÓÐ13È˻ظ´
¡¾ÇóÖú¡¿Óйء°SW0PC_FXGP±à³ÌÈí¼þ¡±µÄ½éÉÜ
ÒѾÓÐ1È˻ظ´
¡¾ÇóÖú¡¿ÓÃMATLAB±à³ÌÇó¼¶ÊýµÄºÍ
ÒѾÓÐ16È˻ظ´
¡¾ÇóÖú¡¿¼±ÇóÊýѧ±à³Ì
ÒѾÓÐ8È˻ظ´
¡¾ÇóÖú¡¿ÇóÒ»¶Î±à³Ì¡¾ÒÑÍê³É¡¿
ÒѾÓÐ7È˻ظ´
» ÇÀ½ð±ÒÀ²£¡»ØÌû¾Í¿ÉÒԵõ½:
¹þ¶û±õ¹¤³Ì´óѧ£¨Çൺ£©¶¯Á¦¹¤³Ì¼°¹¤³ÌÈÈÎïÀíרҵÕÐÆ¸²©Ê¿1Ãû
+1/493
Î÷°²Õ÷½á»éÅ®ÓÑ
+1/271
ÉϺ£º£Ñó´óѧÓëÖйúË®²ú¿ÆÑ§Ñо¿ÔºÁªÅà ѧÊõÐÍÑо¿Éú Ë®²ú (A+ѧ¿Æ£©Óе÷¼ÁÃû¶î
+2/144
¶«±±Ê¯ÓÍ´óѧPCAFMʵÑéÊÒÑо¿Éúµ÷¼ÁÕÐÉú£¨»¯Ñ§»¯¹¤¡¢²ÄÁϵÈÏà¹Ø×¨Òµ£©
+1/85
°²»ÕÊ¡´ó±ðɽÖÐÒ½Ò©Ñо¿Ôº ½ÓÊÕÖÐÒ©µ÷¼ÁÉú£¨ÖÐÒ©¡¢Ò©Ñ§µÈ10¿ªÍ·´úÂë¾ù¿É£©
+1/78
ÄÏͨ´óѧ¹ú¼Ò¼¶È˲ÅÍŶÓÕÐÊÕҩѧ¡¢ÎÀÉú¼ìÑ顢ҽѧ¼ìÑé¡¢»ù´¡Ò½Ñ§Ïà¹Ø·½Ïòµ÷¼ÁÑо¿Éú
+1/37
ÉúÎïÓëҽҩרҵ˶ʿµ÷¼Á£¨ºÓ±±´óѧ »¯Ñ§Óë²ÄÁÏ¿ÆÑ§Ñ§Ôº£©
+2/34
ú̿¿ÆÑ§Ñо¿×ÜÔºÕÐÊÕ2026ÄêÉú̬ѧרҵ˶ʿµ÷¼ÁÉú1Ãû
+1/20
Å·ÃËELIÏîĿ̫ºÕ×ÈС×éÕÐÊÕÌ«ºÕ×ȹâѧ²©Ê¿
+1/20
¡¾¹þ¹¤³Ì¡¿ºËѧԺij¿ÎÌâ×éÕÐÊÕÈ«ÈÕÖÆµ÷¼ÁÑо¿Éú
+1/17
»¯¹¤±ÏÒµÈýÄêתµç×ÓÐÅÏ¢¿ÉÐÐÂ𣿣¿¸÷λͬÐÐǰ±²
+1/8
Äϲýº½¿Õ´óѧ ²ÄÁÏѧԺ ÕвÄÁÏÀàµ÷¼ÁÑо¿Éú£¬Ãû¶î¶à£¬Éϰ¶»ú»á´ó
+1/7
ÆëÆë¹þ¶û´óѧÀîÀò¿ÎÌâ×é³ÏÕÐ2026¼¶¿¼Ñе÷¼ÁÉú
+1/4
´óÍåÇø´óѧÀî¾ü¿ÎÌâ×éÕÐÊÕÉúÎïÐÅϢѧ¡¢È˹¤ÖÇÄÜ·½Ïò²©Ê¿ºó
+1/4
±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº»úÆ÷ÈËÓ¦Óü¼ÊõÑо¿Ëù2026ÄêÕÐÊÕµ÷¼ÁÑо¿Éú£¡
+1/3
Ñγǹ¤Ñ§Ôº²ÄÁÏ¿ÆÑ§Ó빤³Ì/½»Í¨ÔËÊä·½Ïò˶ʿÉúµ÷¼ÁÕÐÉú
+1/3
ÆëÆë¹þ¶û´óѧ»¯Ñ§Ó뻯ѧ¹¤³ÌѧԺÕÐÊÕר˶µ÷¼Á
+1/2
Î人·ÄÖ¯´óѧÉò°®¹ú½ÌÊÚÍŶÓÕÐÊÕ»¯Ñ§¡¢ÉúÎï¡¢²ÄÁÏרҵÑо¿Éú
+1/1
2026Äê±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº»·¾³Ñ§¿Æ-Ë®ÎÛȾ¿ØÖƹ¤³Ì·½Ïò¿ÎÌâ×é»¶ÓÄú
+1/1
ÖØÇ콻ͨ´óѧ¿ÎÌâ×é½ÓÊÕµ÷¼ÁÉú£¨²ÄÁÏÓ뻯¹¤/²ÄÁÏ¿ÆÑ§Ó빤³Ì/½»Í¨ÔËÊä/½»Í¨ÔËÊ乤³Ì£©
+1/1
¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
renyan198251(½ð±Ò+10): ¶àлÁË¡£ 2011-04-28 17:33:14
Сľ³æ(½ð±Ò+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














»Ø¸´´ËÂ¥