| ²é¿´: 620 | »Ø¸´: 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ÓïÑÔ£º¡°Éè¼ÆÒ»¸ö´æ´¢¹ý³Ì£¬²ÉÓÃÄ£ºý²éѯ·½Ê½²éÕÒÖ¸¶¨³ö°æÉçÊé¼®ÐÅÏ¢¡± лл£¡ |
» ²ÂÄãϲ»¶
311Çóµ÷¼Á
ÒѾÓÐ21È˻ظ´
343Çóµ÷¼Á085601
ÒѾÓÐ7È˻ظ´
327Çóµ÷¼Á
ÒѾÓÐ9È˻ظ´
297Çóµ÷¼Á
ÒѾÓÐ5È˻ظ´
²ÄÁϵ÷¼Á
ÒѾÓÐ7È˻ظ´
283·ÖÇóµ÷¼Á
ÒѾÓÐ5È˻ظ´
336Çóµ÷¼Á
ÒѾÓÐ8È˻ظ´
329Çóµ÷¼Á£¬Ò»Ö¾Ô¸Î÷±±¹¤Òµ´óѧ£¬²ÄÁϹ¤³Ì£¨085601£©
ÒѾÓÐ14È˻ظ´
ÊÞÒ½µ÷¼Á
ÒѾÓÐ3È˻ظ´
²ÄÁÏ334Çóµ÷¼Á
ÒѾÓÐ4È˻ظ´
» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:
Çómathematica±à³Ì
ÒѾÓÐ6È˻ظ´
Çó°ï棬¹ØÓÚº¬ÓÐbesselº¯ÊýµÄ·½³ÌµÄ±à³ÌÇó½âÎÊÌâ
ÒѾÓÐ11È˻ظ´
ÓÐÈý¸ö¼ÆËãÎïÀíµÄÌ⣬´ó¼ÒËÄܰï°ïæ°¡£¬ÒªÇó±à³ÌÐò¡£ÎÒŪÁ˺ü¸ÌìÁË£¬Åª²»³öÀ´£¬¿ÒÇë
ÒѾÓÐ18È˻ظ´
ÇóÖúmatlab±à³Ì
ÒѾÓÐ13È˻ظ´
¡¾ÇóÖú¡¿Óйء°SW0PC_FXGP±à³ÌÈí¼þ¡±µÄ½éÉÜ
ÒѾÓÐ1È˻ظ´
¡¾ÇóÖú¡¿ÓÃMATLAB±à³ÌÇó¼¶ÊýµÄºÍ
ÒѾÓÐ16È˻ظ´
¡¾ÇóÖú¡¿¼±ÇóÊýѧ±à³Ì
ÒѾÓÐ8È˻ظ´
¡¾ÇóÖú¡¿ÇóÒ»¶Î±à³Ì¡¾ÒÑÍê³É¡¿
ÒѾÓÐ7È˻ظ´
» ÇÀ½ð±ÒÀ²£¡»ØÌû¾Í¿ÉÒԵõ½:
¹ã¶«¹¤Òµ´óѧ-ľÖÊÏËÎ¬ËØ¸ßÖµ»¯ÀûÓÃÍŶÓÕв©Ê¿Ñо¿Éú
+1/86
ÖпÆÔºÈýÇø£¬Éó¸åËٶȿ죬ÆÚ¿¯Journal of Groundwater Science and Engineering
+1/82
´óÁ¬¹¤Òµ´óѧ ¸ß·Ö×Ó²ÄÁÏ ½ÓÊÕ¿¼Ñе÷¼Á
+1/36
»ªÄÏÀí¹¤´óѧÖÜÞÈÍ®ÀÏʦ¿ÎÌâ×éÕÐÊÕ2026¼¶²©Ê¿Éú-Íâ¹Ç÷À»úÆ÷ÈË
+1/32
ÖØÇ칤ÉÌ´óѧ ½ÌÓý²¿Ñо¿ÖÐÐÄÕÐÊÕ»¯¹¤/»·¾³/²ÄÁÏ/ʯÓÍ/»úе·½Ïò2026Äêµ÷¼ÁÑо¿Éú
+1/10
Öйúũҵ´óѧ×ÊÔ´Óë»·¾³Ñ§Ôº - ÕÐÆ¸½Ü³öÈ˲ţ¨½ÌÊÚ-ר¼¼Ëļ¶£©¡¢ÇàÄêÑо¿Ô±£¨¸±½ÌÊÚ-×
+1/9
»¯¹¤±ÏÒµÈýÄêתµç×ÓÐÅÏ¢¿ÉÐÐÂ𣿣¿¸÷λͬÐÐǰ±²
+1/8
¹þ¹¤´ó»¯¹¤Ñ§ÔºÀîÃɸտÎÌâ×éÕÐÊÕ2026ÄêÇï¼¾Èëѧ²©Ê¿Éú
+1/8
ɽ¶«Å©Òµ´óѧ»¯Ñ§Óë²ÄÁÏ¿ÆÑ§Ñ§Ôº 2026Äê˶ʿÑо¿ÉúÄâ½ÓÊÕµ÷¼Á
+1/7
¡¾µ÷¼ÁÉϰ¶¡¿985ÁªºÏÅàÑø£¡1007/1055/08/07µÈ£¬²»ÏÞרҵ£¬ÏëÁªÅàµÄËÙÀ´£¡
+1/7
³¤½Ê¦·¶Ñ§Ôº ²ÄÁϹ¤³Ì ÕÐÊÕµ÷¼ÁѧÉú
+1/5
ÈýÏ¿´óѧ»·¾³¹¦ÄܲÄÁÏ¿ÎÌâ×éÕÐÉú»¯Ñ§¡¢²ÄÁÏ¡¢»¯¹¤Ë¶Ê¿µ÷¼ÁÉú
+1/4
NTUÕÐÆ¸ÉúÎï΢»úµçϵͳ/΢Á÷¿Ø/3D´òÓ¡/¿É´©´÷Æ÷¼þ·½ÏòÈ«½±²©Ê¿
+1/4
±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº»úÆ÷ÈËÓ¦Óü¼ÊõÑо¿Ëù2026ÄêÕÐÊÕµ÷¼ÁÑо¿Éú£¡
+1/3
±±¾©Ë«Ò»Á÷¸ßУ--»·¾³¿ÆÑ§Ó빤³ÌרҵÕÐÊÕµ÷¼Á
+1/3
2026ÄêÔÆÄÏ´óѧÇà°Î¿ÎÌâ×éÕÐÊÕµØÀíѧ£¬´óÆø¿ÆÑ§¡¢×ÊÔ´Óë»·¾³µÈרҵÑо¿Éú
+1/3
¸ÓÄÏʦ·¶´óѧ¹ùά¿ÎÌâ×éÕÐÊÕ»¯Ñ§ÀࡢҩѧÀà¡¢²ÄÁÏÀàѧ˶¡¢×¨Ë¶¿¼Ñе÷¼Áͬѧ
+1/3
´óÁ¬¹¤Òµ´óѧ¿¼Ñе÷¼Á
+1/3
˶ʿµ÷¼Á£º±±¾©ÐºÍҽѧԺ »ù´¡Ñ§Ôº ÉúÎïҽѧ¹¤³Ìרҵ
+1/3
ÉϺ£Ó¦Óü¼Êõ´óѧ»¯¹¤ÔºÕÐÊÕµ÷¼Á
+1/2
¡ï
Сľ³æ(½ð±Ò+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














»Ø¸´´ËÂ¥