亚洲2019中文字幕无码_ Java過(guò)程修改dump文件成特定字符集

前一段時(shí)間在
http://www.itpub.net/showthread.php...15&pagenumber=1
中討論的DMP不同字符集之間自由轉換工具，經(jīng)過(guò)一位java朋友的幫忙，今天奉獻上biti提議的java存儲過(guò)程修改方法：

DumpChange.java腳本:

import java.io.*;

public class DumpChange
{
public static String ChangeCharSet(String fileName,String value)
throws IOException,NumberFormatException
{
try
{
value=value.trim();
if(value.length()<4)
value=new String("0000"+value).substring(value.length());
else if(value.length()>4)
throw new NumberFormatException(value+"is error,length>4.");
RandomAccessFile raf=new RandomAccessFile(fileName,"rw");
byte[] bts=new byte[2];
bts[0]=new Integer(Integer.parseInt(value.substring(0,2),16)).byteValue();
bts[1]=new Integer(Integer.parseInt(value.substring(2),16)).byteValue();
raf.seek(1);
raf.write(bts);
raf.close();
return "OK";
}
catch(Exception e)
{
return e.toString();
}
}
}

C:\>loadjava -user scott/tiger@ora8db1 -r -f -v c:\yztbak\DumpChange.java
initialization complete
loading : DumpChange
creating : DumpChange
resolver :
resolving: DumpChange

C:\>sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Aug 13 15:35:00 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> conn sys/change_on_install@ora8db1 as sysdba
Connected.
SQL> CREATE OR REPLACE FUNCTION SCOTT.DumpCharSet(FileName in varchar2,HexCharSe
t in varchar2) return varchar2 as language java name ‘DumpChange.ChangeCharSet(j
ava.lang.String,java.lang.String) return java.lang.String‘;
2 /

Function created.
SQL> CREATE OR REPLACE FUNCTION SCOTT.TO_CHARSET
2 (Filename in varchar2,CharSet in varchar2) return varchar2
3 as
4 HexId varchar2(10);
5 ret varchar2(500);
6 begin
7 select to_char(NLS_CHARSET_ID(CharSet),‘xxxx‘) into HexId from dual;
8 HexId:=trim(HexId);
9 select DumpCharSet(Filename,HexId) into ret from dual;
10 return ret;
11 end;
12 /

Function created.

SQL> execute dbms_java.grant_permission(‘SCOTT‘,‘SYS:java.io.FilePermission‘,‘d:
\db_databak\scott.dmp‘,‘read,write‘);

PL/SQL procedure successfully completed.

SQL> select SCOTT.to_charset(‘d:\db_databak\scott.dmp‘,‘ZHS16GBK‘) from dual;

SCOTT.TO_CHARSET(‘D:\DB_DATABAK\SCOTT.DMP‘,‘ZHS16GBK‘)
--------------------------------------------------------------------------------

OK

SQL>

本站僅提供存儲服務(wù)，所有內容均由用戶(hù)發(fā)布，如發(fā)現有害或侵權內容，請點(diǎn)擊舉報。

欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久