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

log4j ¼Ç¼ÈÕÖ¾·ÅÔÚoracleÖÐ

Ò»¸ödbÀà ÀàËÆÓÚjdbcµÄÇý¶¯ºÍÁ´½ÓÅäÖÃ
  package com.assi;
import org.apache.log4j.jdbc.JDBCAppender;
public class DB extends JDBCAppender {
     public DB(){
         this.setDriver("oracle.jdbc.driver.OracleDriver"); 
         this.setURL("jdbc:oracle:thin:@172.18.220.10:1521:orcl"); 
         this.setUser("log"); 
         this.setPassword("log");
     }
}
¾ßÌåдÈÕÖ¾µÄÀà //ûÓÐ×¢ÊÍ ´úÂë±È½Ï¼òµ¥
package com.assi;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.log4j.Level;
import org.apache.log4j.Logger;
public class CataLogs extends DB {
    private DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
    private Logger logger;
    public CataLogs(){
        logger=Logger.getLogger(CataLogs.class.getName());
       
    }
    //×Ô¶¯Ö´ÐеÄ
    protected void execute(String sql){
        Connection con=null;
        PreparedStatement stmt=null;
        try{
            con=getConnection();
            stmt=con.prepareStatement(this.getSql());
            stmt.execute();
        }
        catch(Exception e){
            e.printStackTrace();
     &


Ïà¹ØÎĵµ£º

ORACLEÉÁ»Ø»Ö¸´Çø(Flash recovery area)

oracle10gÐÂÌØÐÔ£ºÉÁ»Ø»Ö¸´Çø(Flash recovery area)
Oracle9i¿ªÊ¼ÌṩÉÁ»Ø²éѯ£¬ÒÔ±ãÄÜÔÚÐèÒªµÄʱºò²éµ½¹ýȥij¸öʱ¿ÌµÄÒ»ÖÂÐÔÊý¾Ý£¬ÕâÊÇͨ¹ýUndoʵÏֵġ£Õâ¸ö¹¦ÄÜÓкܴóµÄÏÞÖÆ£¬¾ÍÊÇÏà¹ØÊÂÎñµÄundo²»Äܱ»¸²¸Ç£¬·ñÔò¾ÍÎÞÁ¦»ØÌìÁË¡£oracle10g´ó´óµÄÔöÇ¿ÁËÉÁ»Ø²éѯµÄ¹¦ÄÜ£¬²¢ÇÒÌṩÁ˽«Õû¸öÊý¾Ý¿â»ØÍ˵½¹ýȥij¸öʱ¿ÌµÄÄÜÁ¦£¬ ......

oracleÊý¾Ý¿âÁ¬½Ó³ØµÄʹÓà [Òý]




Êý¾Ý¿âÁ¬½ÓÊÇÒ»ÖֹؼüµÄÓÐÏ޵ݺ¹óµÄ×ÊÔ´£¬ÕâÒ»µãÔÚ¶àÓû§µÄÍøÒ³Ó¦ÓóÌÐòÖÐÌåÏÖµÃÓÈΪͻ³ö¡£¶ÔÊý¾Ý¿âÁ¬½ÓµÄ¹ÜÀíÄÜÏÔÖøÓ°Ïìµ½Õû¸öÓ¦ÓóÌÐòµÄÉìËõÐԺͽ¡×³ÐÔ£¬Ó°Ïìµ½³ÌÐòµÄÐÔÄÜÖ¸±ê¡£Êý¾Ý¿âÁ¬½Ó³ØÕýÊÇÕë¶ÔÕâ¸öÎÊÌâÌá³öÀ´µÄ¡£
Êý¾Ý¿âÁ¬½Ó³Ø¸ºÔð·ÖÅä¡¢¹ÜÀíºÍÊÍ·ÅÊý¾Ý¿âÁ¬½Ó£¬ËüÔÊÐíÓ¦ÓóÌÐòÖØ¸´Ê¹ÓÃÒ»¸öÏÖÓеÄÊý¾Ý¿ ......

Oracle PL/SQL¿é½á¹¹ºÍ×é³ÉÔªËØÑ§Ï°±Ê¼Ç(Ò»)

Ò»£¬PL/SQL¿éµÄ½á¹¹ºÍ×é³ÉÔªËØ
PL/SQL³ÌÐòÓÉÉùÃ÷²¿·Ö£¬Ö´Ðв¿·Ö£¬Òì³£´¦Àí²¿·ÖÈý¸ö²¿·Ö×é³É¡£½á¹¹ÈçÏ£º
DECLARE
/*ÉùÃ÷²¿·Ö£ºÔÚ´ËÉùÃ÷PL/SQL±äÁ¿£¬ÀàÐͼ°Óα꣬ÒÔ¼°¾Ö²¿µÄ´æ´¢¹ý³ÌºÍº¯Êý*/
BEGIN
/*Ö´Ðв¿·Ö£º¹ý³Ì¼°sqlÓï¾ä£¬³ÌÐòÖ÷Òª²¿·Ö£¬ÊDZØÐëµÄ*/
EXCEPTION
/*Òì³£´¦Àí²¿·Ö£º´íÎó´¦Àí*/
END
 
PL/SQL¿ ......

ROLLUPºÍCUBEÓï¾ä¡£ ORACLE·Ö×éͳ¼Æ


ROLLUPºÍCUBEÓï¾ä¡£
OracleµÄGROUP
BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£Èç¹ûÊÇROLLUP(A, B, C)µÄ»°£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºó¶Ô(A¡¢B)½øÐÐGROUP BY£¬È»ºóÊÇ(A)½øÐÐGROUP BY£¬×îºó¶ÔÈ«±í½øÐÐGROUP BY²Ù×÷¡£Èç¹ûÊÇGROUP BY
CUBE(A, B, C)£¬ÔòÊ×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºóÒÀ´ÎÊÇ( ......

CentOS 5ϰ²×°Oracle 11g

Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶     
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£     
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9i£¬ÔÚ·ÖÅäÁË1GB×óÓҵĽ»»» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ