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
Ïà¹ØÎĵµ£º
Ê×ÏÈÄãÒªÓÐtomcat,»¹ÒªÓÐoracle jdbcµÄjarµµµÈ»·¾³.
µÚÒ»²½: дJSP
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@(des ......
Ò» ǰÌá
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
񡜧mytable
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......
ÈçºÎͨ¹ýSqlplus´´½¨Ò»¸öoracleµÄuser
1£¬Í¨¹ýsystem¹ÜÀíÔ±Á¬½Óµ½ÒªÌí¼ÓUSERµÄDB
»òÕßͨ¹ýÒÔÏÂÃüÁ Connect system/manager@user_datebase AS SYSDBA ;ÒÔSYSµÇ½ȥ´´½¨Óû§
2,´´½¨Óû§²¢·ÖÅäȨÏÞ
drop user asset cascade; ɾ³ ......
Ò»°ãµÄ¹«Ë¾Í¨³£»áÔÚËûÃǵÄÐÅϢϵͳ¼Ü¹¹ÖÐÒýÈë¶àÖÖÊý¾Ý¿âƽ̨£¬Í¬Ê±ÒýÈëÈýµ½ËÄÖÖ²»Í¬µÄRDBMS½â¾ö·½°¸µÄÖдóÐ͹«Ë¾Ò²²¢²»ÉÙ¼û£¬µ±È»ÕâЩ¹«Ë¾ÀïÃæµÄDBAÃÇͨ³£Ò²ÐèҪͬʱӵÓйÜÀí¶àÖÖ²»Í¬Æ½Ì¨µÄ¼¼ÄÜÁË¡£
Ö»ÔÚÒ»ÖÖÆ½Ì¨ÉÏÕ¹¿ª¹¤×÷µÄÊý¾Ý¿âר¼ÒÃÇҲͨ³£»áÆÚ´ý×ÅÔÚËûÃǵÄÏÂÒ»·Ý¹¤×÷ÖÐÄÜѧµ½µã²»Ò»ÑùµÄ¶«Î÷£¬ÄÇЩÓÐÓÂÆøµÄÈËÃÇÔòÔ¸Òâ ......