oracleÖÐsqlЧÂʵÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí
ÕâÁ½ÌõsqlÒâ˼ÊÇ´ÓÌû×Ó±íÖÐÈ¡Ìû×Ó£¬À¸Ä¿Ãû³Æ´Óarticle_lm±íÖлñµÃ select a.tid,a.bt,a.ftr,a.ftsj,b.lmmc from article a left join article_lm b on a.lmid=b.lmid select a.tid,a.bt,a.ftr,a.ftsj,(select lmmc from article_lm where a.lmid=lmid) lmmc from article a ÈçÉÏÁ½ÌõsqlÓï¾ä£¬ÎÒÏëÖªµÀÄÄÌõЧÂʸßһЩ£¬ÎªÊ²Ã´£¿
ÊÔÑéÁË Ï ²î±ð²»ÊǺܴó ÔÚÊý¾ÝÁ¿ 1000 W ÊDzî±ð Ò²²»ÊǺܴó 0.125 £¬0.078 ¸öÈ˸оõÉÏ Á¬½Ó»á ЧÂʸߵã ÒýÓà ÕâÁ½ÌõsqlÒâ˼ÊÇ´ÓÌû×Ó±íÖÐÈ¡Ìû×Ó£¬À¸Ä¿Ãû³Æ´Óarticle_lm±íÖлñµÃ select a.tid,a.bt,a.ftr,a.ftsj,b.lmmc from article a left join article_lm b on a.lmid=b.lmid select a.tid,a.bt,a.ftr,a.ftsj,(select lmmc from article_lm whe¡¡ ²é¿´Ã¿ÌõÓï¾äµÄÖ´Ðмƻ®£¬¾ÍÖªµÀ˵ÄЧÂʸߡ£ ÎÒ¾õµÃÓ¦¸ÃÐÔÄܲ¶à.µ«ÊǾßÌåµÄÊý¾Ý»·¾³ÏÂÃæORACLE¾ö¶¨µÄÖ´Ðмƻ®¿ÉÄÜÓÐÇø±ð.ËùÒÔ×îºÃÊǸù¾ÝÖ´Ðмƻ®À´ºâÁ¿ÄĸöºÃÄĸö²»ºÃ. ¸öÈ˾õµÃµÚ2ÖֱȽϺà fromºóÃæ²»Òª+ºÜ¶à±í ¹âƾÁ½ÌõSQLÓï¾ä˵ЧÂÊÊDz»Ì«×¼È·µÄ ÐèÒª¿´Á½ÕűíÖеÄÊý¾ÝÁ¿ÒÔ¼°ÏàÓ¦Óï¾äµÄÖ´Ðмƻ®À´½øÐÐÅÐ¶Ï ¸öÈ˸оõµÚÒ»ÌõÖ´ÐеÄЧÂʸߣ¬²»ÖªµÀ¶Ô²»¶Ô¡£
Ïà¹ØÎÊ´ð£º
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
SQL code: CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server) µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿ ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......