oracleÈçºÎɾ³ý1Ô·ÝËùÓÐÊý¾Ý - Oracle / ¿ª·¢
oracleÈçºÎɾ³ý1Ô·ÝËùÓÐÊý¾Ý ±íÃûTEST¡¢Ê±¼äÁÐÃûcreate_date
create_date µÄ¸ñʽ Êý¾ÝÀàÐÍ DATEÀàÐÍ ¸ñʽ2010-01-20 14:12:50 3 Â¥Õý½â ÏÂÊÖÕæ¿ì Èç¹ûÊý¾ÝΪº£Á¿Êý¾ÝµÄ»°½¨ÒéʹÓ÷ÖÇø,Ó÷ÖÇøµÄtruncate Òª¸ù¾ÝÔ·ݷÖ×éÔõô·Ö£¿ÎÒ·Ö³öÀ´Êǰ´Ìì·ÖµÄÓôÃÆÁË group by to_char(create_date,'yyyymm') ¿Ï¶¨Èö Èç¹ûÄã°Ñʱ¼äÄÇÁж¼ÁгöÀ´ ¿Ï¶¨ÊǺϲ¢²»Á˵ÄÈö¡£È¥µôʱ¼äÁÐ where create_date>=date'2010-1-1' and create_date<date'2010-2-1' ÎұȽÏϲ»¶Õâôд£¬ÉÙÒ»²ãת»»³É±¾ÒýÓà SQL code delete from test where to_char(create_date,'yyyymm') = '201001' ºÜ¼òµ¥£¬¾ÍÊÇÕâÑùÁË£¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~ ÒýÓà oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
SQL code: CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......