¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
* ´´½¨ÈÕÆÚ£º(2001/11/30 14:55:06)
* @author£ºzhubin
*/
public class BLOBUtil {
/**
* ¹¦ÄÜ˵Ã÷£º±àÂ뷽ʽ
* ȡֵ·¶Î§£º
* ÒÀÀµÊôÐÔ£º
* ×îºóÐÞ¸Äʱ¼ä£º(2002-2-27 15:30:40)
*/
private static String codeSet;
/**
* ´Ë´¦²åÈë·½·¨ËµÃ÷¡£
* ´´½¨ÈÕÆÚ£º(2001/11/30 14:58:15)
* @return java.lang.String
* @param result java.sql.ResultSet
* @param index int
*/
public static String readBLOB(ResultSet result, int index) throws IOException,
SQLException
{
String strValue = null;
// ¶ÔÓÚSQL NULL£¬·½·¨getBinaryStream½«·µ»Ønull
InputStream in = result.getBinaryStream(index);
if (in == null) {
return "";
}
byte[] ba = new byte[8192];
ByteArrayOutputStream b = new ByteArrayOutputStream();
int i;
while((i = in.read(ba)) != -1){
b.write(ba, 0, i);
}
try{
strValue = b.toString(codeSet);
}catch(Exception e){
strValue = b.toString();
}
return strValue;
}
/**
* ´Ë´¦²åÈë·½·¨ËµÃ÷¡£
* ´´½¨ÈÕÆÚ£º(2001/11/30 14:59:52)
* @return java.lang.String
* @param result java.sql.ResultSet
* @param name java.lang.String
*/
public static String readBLOB(ResultSet result, String name) throws IOException,
SQLException
{
String strValue;
// ¶ÔÓÚSQL NULL£¬·½·¨getBinaryStream½«·µ»Ønull
InputStream in = result.getBinaryStream(name);
if (in == null) {
return "";
}
byte[] ba = new byte[8192];
ByteArrayOutputStream b = new ByteArrayOutputStream();
int i;
while((i = in.read(ba)) != -1){
b.write(ba, 0, i);
}
try{
strValue = b.toString(codeSet);
}catch(Exception e){
strValue = b.t
Ïà¹ØÎĵµ£º
OracleÈÏ֤ר¼Ò——OCP£¬ÊÇÓÉOracle¹«Ë¾ÊÚȨ¹ú¼Ê¿¼ÊÔÈÏÖ¤ÖÐÐĶԿ¼Éú½øÐеÄ×ʸñÈÏÖ¤¡£¿¼Éú°´¿¼ÊÔ±ê×¼ÒªÇó²Î¼Ó¼¸Ãſγ̵Ŀ¼ÊÔ(Ò»°ãΪ3—5ÃÅ)£¬ÔÚͨ¹ýÈ«²¿¿¼ÊԺ󣬱ã¿É»ñµÃOCPµÄר¼ÒÈÏÖ¤¡£
ĿǰOCPÈÏÖ¤¿¼ÊÔ·ÖΪ£º
Database AdministratorDatabase OperatoDatabase DeveloperJava DeveloperApplication Consul ......
Ê×ÏȲéÕÒÄ¿±êÓû§µÄµ±Ç°½ø³Ì£º
select sid,serial# from v$session where username='ERP';
²éѯ½á¹û£º
sid serial#
222 123
122 233
Ç¿ÐжϿªÓû§Á¬½Ó£º
alter system kill session 'sid,serial';
ÀýÈ磺
alter system kill session '222,123';
......
ºÜ¶àÈ˶¼Åöµ½¹ýÒòΪ×Ö·û¼¯²»Í¬¶øÊ¹Êý¾Ýµ¼Èëʧ°ÜµÄÇé¿ö¡£ÕâÉæ¼°Èý·½ÃæµÄ×Ö·û¼¯£¬Ò»ÊÇoracel server¶ËµÄ×Ö·û¼¯£¬¶þÊÇoracle client¶ËµÄ×Ö·û¼¯;ÈýÊÇdmpÎļþµÄ×Ö·û¼¯¡£ÔÚ×öÊý¾Ýµ¼ÈëµÄʱºò£¬ÐèÒªÕâÈý¸ö×Ö·û¼¯¶¼Ò»Ö²ÅÄÜÕýÈ·µ¼Èë¡£
¡¡¡¡1¡¢²éѯoracle server¶ËµÄ×Ö·û¼¯
¡¡¡¡ÓкܶàÖÖ·½·¨¿ÉÒÔ²é³öor ......
ÖйúµçÁ¦ÐÐҵĿǰÕýÔÚ¾Àúמ޴óµÄ±ä»¯£º´Ó¹ú¼Ò°ìµçµ½ÆóÒµ°ìµç£¬ÐγÉÁ˶à¼Ò¾ºÕù°ìµçµÄ¸ñ¾Ö£»³§Íø·Ö¿ª¡¢¾º¼ÛÉÏÍø£¬´Ó¼Æ»®µ½Êг¡×ª¹ì£¬ÒýÈë¶àÖÖ¾¼Ã³É·Ö£»´ÓµØÓòÐÔ·ÖÉ¢¹©µçÏò´óµçÍø·¢Õ¹£»´ÓÕþÆó²»·Öµ½ÕþÆó·Ö¿ª¡£ÕâЩ±ä»¯£¬Ê¹ÖйúµÄµçÁ¦ÐÐÒµ¾ÊÜ×ÅǰËùδÓеÄѹÁ¦¡£
Ò»·½Ã棬2003Äê¹úÄڵķ¢µçÆóÒµÖØÐ¸Ä×é£ ......
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) value
O:selec ......