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

µ±oracle³öÏÖ ¸ñʽÓë×Ö·û´®¸ñʽ²»Æ¥Åä½â¾ö°ì·¨

    select v.spid spid,v.appid appid,v.version version,v.newversion newversion,v.status status,v.createtime createtime from adc_spversionchangeapply v inner join adc_application a on a.id=v.appid
    where a.create_by = 'a' and v.appid = '12000000005' and  (v.createtime >= '1987-05-06') and (v.createtime <= '2009-04-29')
¼ÓÈëv.createtimeÔÚÊý¾Ý¿âÖÐÊÔdateÀàÐÍ  ÄÇô»áÅܳöÒì³£
ORA-01861: ÎÄ×ÖÓë¸ñʽ×Ö·û´®²»Æ¥Åä
ʵ¼ÊÉÏÊÇÒòΪ '1987-05-06'ÊÇ×Ö·û´®ÀàÐ͵¼ÖµÄdateÀàÐÍÓë×Ö·û´®ÀàÐÍ ¼þ¿çÀàÐÍ±È½Ï ËùÒÔÊÇÓÐÎÊÌâµÄ
½«'1987-05-06'  д³Éto_date('1987-09-18','yyyy-mm-dd')
¾ÍÐÐÁË
´úÂëÈçÏÂ
    select v.spid spid,v.appid appid,v.version version,v.newversion newversion,v.status status,v.createtime createtime from adc_spversionchangeapply v inner join adc_application a on a.id=v.appid
    where a.create_by = 'a' and v.appid = '12000000005' and  (v.createtime >= to_date('1987-05-12','yyyy-mm-dd')) and (v.createtime <= to_date( '2009-04-29','yyyy-mm-dd')


Ïà¹ØÎĵµ£º

oracleÖÐ ÕýÔÚÁ¬½Ó...ORA 12541: TNS: ûÓмàÌý³ÌÐò

¶ÔÓÚ×°ºÃÁ˸ÃÈí¼þºó,ÀûÓÃsystemÊÇÄܵǽøÈ¥µÄ,»ú×ÓÖØÆôºó,³öÏֵĸÃÎÊÌ⣺
    ¿ÉÄÜÄú ÔËÐÐ--sqlplusw  ÊÇÄܵÇÉÏÈ¥µÄ  ¶ø»»³ÉPL/SQL Developer È´Á¬²»ÉÏ ·þÎñÆ÷,Èç¹ûÄúÈ·¶¨ÄãµÄ·þÎñ¿ªÆôÁË
    ËÑË÷ÕÒµ½tnsnames.oraºÍlistener.oraÎļþ, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µ ......

oracle ¼ì²é±»ËøµÄ±í¼°½âËø

Ô­ÎĵØÖ·£ºhttp://tech.e800.com.cn/articles/2009/710/1247207067745_1.html
´¦Àí·½·¨Ò» £º

¼ì²éÄĸö±í±»Ëø
select sess.sid,sess.serial#,
lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from
v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id =
lo.object_id
......

OracleÊý¾ÝÀàÐͼò½é¡¾×ªÌù¡¿

OracleÊý¾ÝÀàÐͼò½é
¡¡¡¡Ò»¡¢¸ÅÊö
¡¡¡¡ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿£¨SCALAR£©¡¢¸´ºÏ£¨COMPOSITE£©¡¢ÒýÓã¨REFERENCE£©ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ£¬ÏÂÃæÏêϸ½éÉÜËüÃǵÄÌØÐÔ¡£
¡¡¡¡¶þ¡¢±êÁ¿£¨SCALAR£©
¡¡¡¡ºÏ·¨µÄ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿É ......

ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ

ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ
 
-- ±í
create table test (names varchar2(12),
                   dates date,
               &nb ......

OracleÖÐÀûÓÃTrigger½øÐй¤×÷

OracleÊý¾Ý¿âÖÐ,ÓÐЩÇé¿öÏÂ,¶ÔÊý¾Ý¼Ç¼ÐèÒª¼Ç¼ÈÕÖ¾,»ò±£´æ²Ù×÷ÀúÊ·µÈÇé¿ö.ÔÚ´ËÎÒÃÇ¿ÉÒÔ½èÖú“Êý¾Ý¿âTrigger”½øÐС£ÏÂÃæÒÔÒ»Àý½øÐÐ˵Ã÷£º
CREATE OR REPLACE TRIGGER aits_auth_group_auth_trga_diu
  AFTER update OR DELETE OR  INSERT on  aits_authority_group_auth
  for each row ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ