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

OracleÖеÄÈÕÆÚÀàÐͼ°ÆäÏà¹ØµÄº¯Êý

Oracle
ÖеÄÈÕÆÚÀàÐͼ°ÆäÏà¹ØµÄº¯Êý
Oracle
ÌṩÁ˺ܶàµÄÄÚÖõÄÈÕÆÚÀàÐÍ£¬°üÀ¨Èçϼ¸ÖÖ£º
Date
Timestamp
Timestamp With Time Zone
Timestamp With Local Time Zone
Interval Year To Month
Interval Day To Second
DateÀàÐÍÓÃÓÚ´æ´¢ÈÕÆÚ£¬¾«È·µ½Ã룬¿ÉÄÜͨ¹ýÉèÖÃNLS_DATE_FORMAT»òÕßTO_CHAR·½·¨À´¸ñʽ»¯ÈÕÆÚµÄÊä³ö¡£
TimestampÓÃÓÚ´æÔÚÈÕÆÚÓëʱ¼äÐÅÏ¢£¬Õâ¸öÀàÐͱÈDate¸ü¾«È·£¬×îСÄܾ«È·µ½Ð¡Êýµãºó9λ¡£ÏÂÃæÊÇÒ»¸öÀý×Ó£º
scott@ORCL> select nowDate,nowTimestamp from testtime;
NOWDATE   NOWTIMESTAMP
--------- -------------------------------
24-NOV-08 24-NOV-08 10.36.59.000000000 PM
Timestamp With Time ZoneÀàÐÍÓëTimestamp·Ç³£ÏàËÆ£¬Ö»ÊÇÊǰ´ÕÕÖ¸¶¨Ê±Çø½øÐÐÏÔʾ¡£
Timestamp With Local Time Zone  ÀàÐÍÒÔÉÏÃæµÄ¸ü¼ÓÏàËÆ£¬ÕâÀïÊǰ´ÕÕµ±Ç°Ê±ÇøÏÔʾʱ¼ä¡£
ÏÂÃæÊÇÒ»¸öÀý×Ó£º
scott@ORCL>select * from testtime;
NOWDATE   NOWTIMESTAMP                  TIMEWITHZONE            TIMEWITHLOCALZONE
--------- ----------------------------------- -----------------------------------
24-NOV-08 24-NOV-08 10.44.55.000000000 PM     24-NOV-08 10.44.55.000000 PM +08:00 24-NOV-08 10.44.55.000000 PM
¿ÉÒÔʹÓÃALTER SESSION SETÀ´ÉèÖÃTimestampµÄÊä³ö£¬È磺
scott@ORCL> ALTER SESSION SET NLS_DATE_FORMAT =
                          'YYYY-MM-DD HH24:MI:SS';
Session altered.
scott@ORCL> ALTER SESSION SET NLS_TIMESTAMP_FORMAT
                      = 'YYYY-MM-DD HH24:MI:SS.FF';
Session altered.
scott@ORCL> ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT
                     = 'YYYY-MM-DD HH24:MI:SS.FFTZH:TZM';
Session altered.


Ïà¹ØÎĵµ£º

OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶ ......

±¸·Ý/»Ö¸´OracleÊý¾Ý¿â

1¡¢±¸·ÝÖ¸¶¨µÄ±í¿Õ¼ä
Ê×ÏÈ£¬ÄãҪȷÈÏ×Ô¼ºµçÄÔÉÏÓÐexp.exeÕâ¸ö¶«¶«£¬²ÅÄܽøÐб¸·Ý¹¤×÷¡£
ÎÒÏëÒª±¸·ÝµÄÊÇÓû§ÃûΪcyyµÄ±í¿Õ¼ä£¬±¸·ÝÎļþ´òËã·ÅÔÚDÅÌ£¬²¢ÒÔbackup_oracle.dmpÃüÃû£¬Ë³±ã°ÑÈÕÖ¾ÎļþÒ²±¸·ÝһϺÃÁË¡£
ÔÚÃüÁîÐÐÇÃÈ룺
C:\Documents and Settings\Administrator>exp cyy/cyy@bsrs file=D:\backup_oracle.dmp ......

oracle mutex

An introduction to Mutexes in 10gR2
By Connie Green, Kumar Rajamani
from meetings with: Kumar Rajamani, Russell Green, Saureen Shah, Cecilia Gervasio and Connie Green
Introduction
This paper is intended as an introduction to mutexes.  It describes new concepts associated with mutexes, when ......

Oracle·ÖÎöº¯Êý²Î¿¼ÊÖ²á

תÖÁ(http://xsb.itpub.net/post/419/33028)
22/06/2005 12:22 FP
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ
×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊǶÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÀý×ÓÖÐʹÓõıíÀ´×ÔOracle×Ô´øµÄHRÓû§ÏÂµÄ±í£¬Èç¹û
ûÓа²×°¸ÃÓû§£¬¿ÉÒÔÔÚSYSÓû§ÏÂÔËÐÐ ......

Oracle±¸·Ý

±¸·ÝµÄ·½·¨
    ORACLEÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý¡£µ¼³ö/µ¼Èë(EXPORT/IMPORT) ¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£
    µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼­±¸·Ý£¬ÕâÖÖ·½·¨°üÀ¨¶ÁȡһϵÁеÄÊý¾Ý¿âÈÕÖ¾£¬²¢Ð´ÈëÎļþÖУ¬ÕâЩÈÕÖ¾µÄ¶ÁÈ¡ÓëÆäËù´¦Î»ÖÃÎ޹ء£
    À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý(Ò²³ÆµÍ¼¶±¸·Ý)£¬ËüÉæ¼°µ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ