Oracle¼ÆËãʱ¼ä²î±í´ïʽ
ÓÐÁ½¸öÈÕÆÚÊý¾ÝSTART_DATE£¬END_DATE£¬ÓûµÃµ½ÕâÁ½¸öÈÕÆÚµÄʱ¼ä²î£¨ÒÔÌ죬Сʱ£¬·ÖÖÓ£¬Ã룬ºÁÃ룩£º
Ì죺
ROUND(TO_NUMBER(END_DATE - START_DATE))
Сʱ£º
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24)
ᅅ
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60)
Ã룺
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60 * 60)
ºÁÃ룺
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60 * 60 * 60)
Ïà¹ØÎĵµ£º
ÕÛÌÚÁËÁ½¸öÍíÉϵÄlinuxºÍoralce£¬×ÜËã³öÀ´µã¶«Î÷ÁË¡£Oralce°²×°ÒªÑ¡ÓÃÊÊÓõİ汾£¬²»È»°²×°²»»á³É¹¦£¬×îºóÎҵľö¶¨ÊÇlinuxÑ¡ÓÃcentos 5.0£¬oracleÑ¡ÓÃ10¡£
Ò»¡¢ ×¼±¸¹¤×÷£º
1. ʹÓÃrootÓû§µÇ¼
ÎÒʹÓõÄÊÇÔÚ±¾»ú×°£¬ËùÒÔÖ±½Ó´ò¿ªÖÕ¶Ë¾Í ......
OracleÊý¾ÝÀàÐͼò½é
¡¡¡¡Ò»¡¢¸ÅÊö
¡¡¡¡ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿£¨SCALAR£©¡¢¸´ºÏ£¨COMPOSITE£©¡¢ÒýÓã¨REFERENCE£©ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ£¬ÏÂÃæÏêϸ½éÉÜËüÃǵÄÌØÐÔ¡£
¡¡¡¡¶þ¡¢±êÁ¿£¨SCALAR£©
¡¡¡¡ºÏ·¨µÄ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£ËüÓÖ·ÖΪÆ߸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿É ......
Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
expµ¼³ö¹¤¾ß½«Êý¾Ý¿âÖÐÊý¾Ý±¸·ÝѹËõ³ÉÒ»¸ö¶þ½øÖÆϵͳÎļþ.¿ÉÒÔÔÚ²»Í¬OS¼äǨÒÆ
ËüÓÐÈýÖÖģʽ£º
a. Óû§Ä£Ê½£º µ¼³öÓû§ËùÓжÔÏóÒÔ¼°¶ÔÏóÖеÄÊý¾ ......
OracleÖÐÐÞ¸ÄSequence·½·¨£º¾ÍÊǸıäËüµÄincrement µÝÔö´óС£¬Ëü¿ÉÒÔΪÕýÒ²¿ÉÒÔΪ¸º¡£ÈçÏ£º
SQL> select seq.nextval from dual;
NEXTVAL
----------
21
SQL> alter sequence seq increment by 79;
ÐòÁÐÒѸü¸Ä¡£
SQL> select seq.nextval from d ......
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 ......