µ±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')
Ïà¹ØÎĵµ£º
¶ÔÓÚ×°ºÃÁ˸ÃÈí¼þºó,ÀûÓÃsystemÊÇÄܵǽøÈ¥µÄ,»ú×ÓÖØÆôºó,³öÏֵĸÃÎÊÌ⣺
¿ÉÄÜÄú ÔËÐÐ--sqlplusw ÊÇÄܵÇÉÏÈ¥µÄ ¶ø»»³ÉPL/SQL Developer È´Á¬²»ÉÏ ·þÎñÆ÷,Èç¹ûÄúÈ·¶¨ÄãµÄ·þÎñ¿ªÆôÁË
ËÑË÷ÕÒµ½tnsnames.oraºÍlistener.oraÎļþ, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µ ......
ÔÎĵØÖ·£º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Êý¾ÝÀàÐͼò½é
¡¡¡¡Ò»¡¢¸ÅÊö
¡¡¡¡ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿£¨SCALAR£©¡¢¸´ºÏ£¨COMPOSITE£©¡¢ÒýÓã¨REFERENCE£©ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ£¬ÏÂÃæÏêϸ½éÉÜËüÃǵÄÌØÐÔ¡£
¡¡¡¡¶þ¡¢±êÁ¿£¨SCALAR£©
¡¡¡¡ºÏ·¨µÄ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿É ......
ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ
-- ±í
create table test (names varchar2(12),
dates date,
&nb ......
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
......