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

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


Ïà¹ØÎĵµ£º

jsp·ÖÒ³£¨oracle+jsp+apache£©

Ò» Ç°Ìá 
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
±í£ºmytable 
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......

oracleÖÐjdbcÇý¶¯°üµÄ˵Ã÷

´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐÆ½Ì¨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂÊ¹Ó ......

Oracle RAC ¾²Ä¬°²×°Êµ¼ù

°²×°
1.    Íê³ÉRAC°²×°Ç°µÄ×¼±¸¹¤×÷
1.1      ͬÕý³£°²×°Oracle RACµÄ°²×°Ç°ÅäÖá£Ö÷Òª°üÀ¨ÒÔϼ¸¸ö²¿·Ö£º
£¨1£©  ÈíÓ²¼þ»·¾³¼ì²é
£¨2£©  ÍøÂçÅäÖÃ
£¨3£©  Ïà¹ØÓû§ºÍĿ¼µÄ´´½¨
£¨4£©  Óû§»·¾³¼°ÏµÍ³»·¾³ÉèÖÃ
£¨5£©  ÅäÖÃÔ¶³Ì·ÃÎÊ
£¨6£©  ......

Oracle ×Ö¶ÎÀàÐÍ

ÔÚ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 ......

ÈçºÎͨ¹ýSqlplus´´½¨Ò»¸öoracleµÄuser

ÈçºÎͨ¹ýSqlplus´´½¨Ò»¸öoracleµÄuser
1£¬Í¨¹ýsystem¹ÜÀíÔ±Á¬½Óµ½ÒªÌí¼ÓUSERµÄDB
»òÕßͨ¹ýÒÔÏÂÃüÁ Connect   system/manager@user_datebase   AS   SYSDBA  ;ÒÔSYSµÇ½ȥ´´½¨Óû§
2,´´½¨Óû§²¢·ÖÅäȨÏÞ
drop   user   asset   cascade;  ɾ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ