OracleÖеÄto_date£¨£©
OracleÖÐto_date()Óë24СʱÖƱíʾ·¨¼°mm·ÖÖÓµÄÏÔʾ£º
ÔÚʹÓÃOracleµÄto_dateº¯ÊýÀ´×öÈÕÆÚת»»Ê±£¬ºÜ¶àJava³ÌÐòÔ±Ò²Ðí»áºÍÎÒÒ»Ñù£¬Ö±¾õµÄ²ÉÓÓyyyy-MM-dd HH:mm:ss”µÄ¸ñʽ
×÷Ϊ¸ñʽ½øÐÐת»»£¬µ«ÊÇÔÚOracleÖлáÒýÆð´íÎ󣺓ORA 01810 ¸ñʽ´úÂë³öÏÖÁ½´Î”¡£È磺
to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mm:ss') ;
ÔÒòÊÇSQLÖв»Çø·Ö´óСд£¬MMºÍmm±»ÈÏΪÊÇÏàͬµÄ¸ñʽ´úÂ룬ËùÒÔOracleµÄSQL²ÉÓÃÁËmi´úÌæ·ÖÖÓ¡£
to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mi:ss') ;
ÁíÒªÒÔ24СʱµÄÐÎʽÏÔʾ³öÀ´ÒªÓÃHH24
Ïà¹ØÎĵµ£º
°²×°
1. Íê³ÉRAC°²×°Ç°µÄ×¼±¸¹¤×÷
1.1 ͬÕý³£°²×°Oracle RACµÄ°²×°Ç°ÅäÖá£Ö÷Òª°üÀ¨ÒÔϼ¸¸ö²¿·Ö£º
£¨1£© ÈíÓ²¼þ»·¾³¼ì²é
£¨2£© ÍøÂçÅäÖÃ
£¨3£© Ïà¹ØÓû§ºÍĿ¼µÄ´´½¨
£¨4£© Óû§»·¾³¼°ÏµÍ³»·¾³ÉèÖÃ
£¨5£© ÅäÖÃÔ¶³Ì·ÃÎÊ
£¨6£©  ......
СÐÍ»ú·Ïߣ¬¼¸ºõÒѱ»·âËÀ¡£ÎÞ·¨Ê¹ÓÃSun£¬ËüÒѺÍOracle½ôÃܰ󶨣¬Èô»¹Ê¹ÓÃÉÏÊöÉè¼Æ£¬»áºÜÄÑ˵·þÊÛÇ°½«Ð¡ÐÍ»ú¡¢´æ´¢¡¢Êý¾Ý¿â·Ö±ð´Ó²»Í¬³§É̲ɹº£»ÁíÍ⣬ÒàÎÞ·¨Ê¹ÓÃIBM£¬¾Ý˵FLYµÄij¸öÀϰ岻ϲ»¶¡£ ´óÁ¦ÍƽøÊý¾Ý¿âϵͳPC»¯£¬ÕâËƺõÊÇ×î¼Ñ²ßÂÔ¡£FLYÓ¦ÓöÔÊý¾Ý ......
ÔÚOracle¹ØÓÚʱ¼äÊôÐԵĽ¨±í
Example:
create table courses(
cid varchar(20) not null primary key,
cname varchar(20) not null,
ctype integer,
ctime date DEFAULT SYSDATE,
cscore float not null
)
insert into courses values('ss01','.NET',0,TO_DATE('2009-8-28','yyyy-mm-dd'),94)
insert into course ......
ÓÐʱºòÍøÂç·¢Éú±ä¶¯£¬±ØÐëÊÖ¶¯ÐÞ¸ÄÒ»ÏÂRAC VIPµØÖ·£¬²»½öÊǵØÖ·£¬Ò²¿ÉÒÔÐÞ¸ÄVIPËùÔÚµÄÍø¿¨£¬ÔÔòÊÇVIPµØÖ·ÒªºÍPUBµØÖ·ÔÚͬһ¸öÍø¶ÎÄÚ£¬·½·¨ÆäʵÊDZȽϼòµ¥µÄ£¬ÓÐÈËÎʵ½£¬ÎÒ¸øÒ»¸öʾÀýÈçÏ£º
1¡¢¹Ø±ÕÊý¾Ý¿â
srvctl stop database -d db
2¡¢¹Ø±ÕNOTEAPPA
srvctl stop nodeapps -n db2
à ......
²é¿´Ëø±í½ø³ÌSQLÓï¾ä1£º
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 ......