Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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'

ºÜ¼òµ¥£¬¾ÍÊÇÕâÑùÁË£¡


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

oracleÁ½¸öÊý¾Ý¿âµÄͬ²½£¿ - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿

ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ