ITPub博客

<style.v\:* {behavior.:url(#default#VML);}o\:* {behavior.:url(#default#VML);}w\:* {behavior.:url(#default#VML);}.shape {behavior.:url(#default#VML);}</style. Normal 0 0 2 ...

Service nameSelect * from dba_servicesalter system set service_names=a,b,c,d; select service_name from v$session where sid=(select sid from v$mystat where rownum=1)  àcheck the service...

Normal 0 0 2 false false false MicrosoftInternetExplorer4 <style.st1\:*{behavior.:url(#ieooui) }</style.<styl...

Scn_to_timestamp and Timestamp_to_scn SQL> select current_scn,to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') from v$database; CURRENT_SCN TO_CHAR(SYSDATE,'YY----------- ------------------- 12529246 2012/06/18 13:14:19 SQL> select scn_to_timestamp(12529246) from dual; SCN_TO_TIMESTAMP(12529246)---------------------------------------------------------------------------18-JUN-12 01.14.18.000000000 PM SQL> select systimestamp from dual; SYSTIMESTAMP------------------------------------