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

Oracle ʱ¼ä±È½Ï

    ÔÚWeb¿ª·¢ÖУ¬´ÓÒ³Ãæ×¢ÈëµÄʱ¼äÒ»°ãΪStringÀàÐÍ£¬ÔõôȥºÍOracleÖеÄʱ¼ä½øÐбȽÏ
   ·½·¨£º
  
   String Time£»
   .......// Ò»¶Î´úÂë
   ¼ÙÉèTimeÎªÒ³Ãæ×¢ÈëStringÀàÐÍÊý¾Ý£¬Îª"2010-10-10 12:02:01"¡£
   ÔÚдSQLÓï¾äʱ
   
            String sql="select from  mytable where table_time > to_date('"+Time+"','yyyy-mm-dd
hh24:mi:ss')"
;
   Èç¹ûÏȰÑTime ת»»³É Date ÀàÐÍ£¬ÔÙÈ¥±È½Ï£¬»á±¨´í¡£


Ïà¹ØÎĵµ£º

Oracle Purchasing²»Äܲ鿴POºÍ開PO

      Oracle Purchasing²»Äܲ鿴PO»ò開PO,並ÇÒÓÃ戶ÓÐ權ÏÞ開PO¡£這樣Çé況¿ÉÄÜÓв»ÉÙͬÈÊÒ²ÓöÉÏ類ËÆ問題¡£¾ß體Çé況ÈçÏÂ圖:
     
      Ê×ÏÈ,²é¿´Óà ......

Ê·ÉÏ×îÇ¿µÄFQA for ORACLE(±¸·ÝÓë»Ö¸´²¿·Ö)

Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
[A]Èç¹û¿ªÆô¹éµµ£¬Çë±£Ö¤log_archive_start=true¿ªÆô×Ô¶¯¹éµµ£¬·ñÔòÖ»ÄÜÊÖ¹¤¹éµµ£¬Èç¹ûÊǹرÕÁ˹鵵£¬ÔòÉèÖøòÎÊýΪfalse
×¢Ò⣺Èç¹ûÊÇOPS/RAC»·¾³£¬ÐèÒªÏȰÑparallel_server = true×¢Ê͵ô£¬È»ºóÖ´ÐÐÈçϲ½Ö裬×îºóÓÃÕâ¸ö²ÎÊýÖØÐÂÆô¶¯
1¡¢¿ªÆô¹éµµ
a. ¹Ø±ÕÊý¾Ý¿âshutdown im ......

oracle Ïà關µÄsql語¾ä

Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;
¡¡¡¡¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡¡¡¡¡select tablespace_name,sum(bytes), sum(b ......

ORACLEÊý¾Ý¿âɵ¹ÏÊÖ²á

Oracleɵ¹ÏÊÖ²á
¡¡¡¡
¡¡¡¡Oracle8ÒÔ8.1.5Ϊ½ç·ÖΪÆÕͨ°æ±¾ºÍinternet°æ±¾¡£ÆÕͨ°æ°æ±¾ºÅ8.0.x£¬½Ó´¥½Ï¶àµÄÊÇ8.0.5£»internet°æ°æ±¾ºÅ°üÀ¨8.1.5£¨Release 1£©£¬8.1.6£¨Release 2£©£¬8.1.7£¨Release 3£©¡£ÆÕͨ°æ¼ò³ÆOracle 8£¬internet°æ¼ò³ÆOracle 8i¡£¼ÙÈç²»×÷·Ç·²ËµÃ÷£¬ÎÄÖз²³öÏÖOracle 8i¾ùÖ¸8.1.7°æ¡£
¡¡¡¡Oracle9 ......

ÈçºÎÔÚORACLEÖе¼Èëµ¼³ödmpÎļþ£¿

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
DOSÖп ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ