首页 > 数据库 > Oracle > Java Environment Preparing - Oracle 9i Java Programming I

Java Environment Preparing - Oracle 9i Java Programming I

原创 Oracle 作者:jinava 时间:2005-01-02 01:35:30 0 删除 编辑


define _editor=vi -- can set as notepad, emacs ...

set serverouput on size 1000000 -- set the default buffer size as long as possible
call dbms_java.set_output(1000000); -- redirects the Java ssytem.out to sqlplus session dbms.output buffer

set trimspool on
set sqlblankline on
set long 5000 -- number of bytes displayed when selecting the LONG or CLOB columns
set linesize 300 pagesize 9999

column plan_plus_exp format a80 -- width of the explain plan output
column global_name new_value gname

set termout off
seletct lower(user) || '@' || decode(global_name, 'SKYDIVE', 'DATABASE', '9I', '8I', global_name) global_name from global_name;
set sqlprompt '&gname> '
set termout on

Windows Java Environment:

set JAVA_HOME=C:j2sdk1.4.1_02
set ORACLE_HOME=C:oracleora92
set PATH=C:oracleproduct10.1.0db_1bin;C:oracleproduct10.1.0db_1jre1.4.2binclient;C:oracleproduct10.1.0db_1jre1.4.2bin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Program FilesATI TechnologiesATI Control Panel;C:PROGRA~1COMMON~1SONICS~1;C:PROGRA~1ULTRAE~1
echo C:oracleora92bin;C:Program FilesOraclejre1.3.1bin;C:Program FilesOraclejre1.1.8bin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Program FilesATI TechnologiesATI Control Panel;C:PROGRA~1COMMON~1SONICS~1;C:PROGRA~1ULTRAE~1
set CLASSPATH=.;%JAVA_HOME%;%JAVA_HOME%lib;%JAVA_HOME%libtools.jar;;; this package contains all the Oracle JDBC classes to connect to the database., in the %ORACLE_HOME%sqljlib to translate and compile SQLJ-based code.


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: OEM
下一篇: Oracle 10G
请登录后发表评论 登录
  • 博文量
  • 访问量