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' ºÜ¼òµ¥£¬¾ÍÊÇÕâÑùÁË£¡
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ 1,2,3,4 ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û 1 2 3 4 ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö??? ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó SQL code: wi ......
½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º SQL code: update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿ ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......