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

oracleÅúÁ¿(batch)²Ù×÷µÄʹÓÃ

    /**
     * ¸üмǼ£¬Ô­×Ó²Ù×÷£¬²»»ácommit
     * @param sql_id
     * @param condition
     * @return
     * @throws SQLException
     */
    public boolean updateBatchSql(String sql, List<List<String>> conditions) throws SQLException {
        boolean b = false;
        if (sql == null || sql.trim().length() == 0) {
            return b;
        }
        Connection conn = null;
        ResultSet rs = null;
        PreparedStatement pstmt = null;
        //Ö´ÐÐsql
        try {
            conn = handler.getConnection();
            pstmt = conn.prepareStatement(sql);
            //Ñ­»·¸³Öµ
            for (List<String> condition : conditions) {
                for (int i = 0; i < condition.size(); i++) {
                    pstmt.setString(i + 1, condition.get(i));
                }
                pstmt.addBatch();
            }
    &


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

±ØÐëÒýÆðDBAÖØÊÓµÄOracleÊý¾Ý¿âË鯬

À´Ô´£º[url]http://www.wangchao.net.cn/bbsdetail_1788053.html[/url]
Ŀǰ£¬OracleÒѾ­¹ã·ºµÄÓ¦ÓÃÓÚ¸÷¸öÐÐÒµ¡£×÷ΪһÃûDBA£¬¼°Ê±·¢ÏÖ²¢ÕûÀíË鯬ÒѾ­³ÉΪDBAÈÕ³£¹¤×÷ÖеÄÒ»ÏîÖØÒªÎ¬»¤ÄÚÈÝ¡£ 1¡¢Ë鯬ÊÇÈçºÎ²úÉúµÄ µ±Éú³ÉÒ»¸öÊý¾Ý¿âʱ£¬Ëü»á·Ö³É³ÆÎª±í¿Õ¼ä(tablespace)µÄ¶à¸öÂß¼­¶Î(segment)£¬Èçϵͳ(system)±í¿Õ¼ä,ÁÙʱ(te ......

oracleÕýÔò±í´ïʽ

oracleµÄÕýÔò±í´ïʽ(regular expression)¼òµ¥½éÉÜ
Ŀǰ£¬ÕýÔò±í´ïʽÒѾ­ÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ ÖØ¸´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
Orac ......

Oracle Decodeº¯Êý

DECODEº¯ÊýÏ൱ÓÚÒ»Ìõ¼þÓï¾ä(IF).Ëü½«ÊäÈëÊýÖµÓ뺯ÊýÖеIJÎÊýÁбíÏà±È½Ï£¬¸ù¾ÝÊäÈëÖµ·µ»ØÒ»¸ö¶ÔÓ¦Öµ¡£º¯ÊýµÄ²ÎÊýÁбíÊÇÓÉÈô¸ÉÊýÖµ¼°Æä¶ÔÓ¦½á¹ûÖµ×é³ÉµÄÈô¸ÉÐòżÐÎʽ¡£µ±È»£¬Èç¹ûδÄÜÓëÈκÎÒ»¸öʵ²ÎÐòżƥÅä³É¹¦£¬Ôòº¯ÊýÒ²ÓÐĬÈϵķµ»ØÖµ¡£Çø±ðÓÚSQLµÄÆäËüº¯Êý£¬DECODEº¯Êý»¹ÄÜʶ±ðºÍ²Ù×÷¿ÕÖµ.
Æä¾ßÌåµÄÓï·¨¸ñʽÈçÏ£º
DE ......

ORACLEÎﻯÊÓͼ Query RewriteµÄÒ»°ãÀí½âÖ®Îå


 ¶ÔÓÚÒ»¸ö¸ø¶¨µÄSQL, ºÍÏÖÓеÄMVIEW, Õâ¸öSQL¿ÉÄܱ»Rewrite, Ò²¿ÉÄܲ»Äܱ»Rewrite, ÈçºÎÕÒ³öÕâÆäÖеÄÔ­ÒòÄØ, ¿¿¾­Ñé¿ÉÒÔ½â¾öһЩÎÊÌâ, ²»¹ýËù»¨µÄʱ¼ä¾ÍÒª³¤Ò»µãÁË. ÆäʵÔÚOracleÖÐÌṩÁËÒ»¸öº¯Êý¿ÉÒÔÓÃÓÚ½âÊÍΪʲôij¸öSQL²»Äܱ»ÖØÐ´, Õâ¸ö¹ý³ÌλÓÚdbms_mviewÕâ¸ö°üÖÐ, ¹ý³ÌÃûΪexplain_rewrite, ÓÐÁËÕâ¸ö¹¤¾ß, ¿ÉÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ