2009 年文章归档
共 44 篇文章
PL/SQL三种集合类型的比较
PL/SQL三种集合类型的比较 集合是指在一个程序变量中包含多个值。PL/SQL提供的集合类型如下: Associative Array: TYPE t IS TABLE OF something INDEX BY PLS_INTEGER; Nested Table: TYPE t IS TABLE OF something; VARRAY: TYPE t IS VARRAY (123) OF something; 三种集合的各自使用范围 前提是在PL/SQL中希望某种类型的多个值,并且希望使用myarray[n]的形式访问。 范围:SQL or PL/SQL 最大的区别是首先需要确定使用范…
2009-07-12 13:19 · Oracle
一直在linux下运行服务器,今天尝试了一下windows下的websphere,也很不错
1. 默认的websphere试用版安装作为一个windows服务,启动的时候会出错,所以,安装后要删除, wasservice -remove robertNode01, robertNode01 is the windows service name. 2. Start the websphere, startServer.bat server1 3. Console http://localhost:9060/ibm/console 4. Sample https://localhost:9443/PlantsByWebSphere
2009-06-26 20:45 · J2SE&J2EE
Replace text in file
Windows @echo off if %1%.==. ( echo Usage: %0% FILE_FULL_PATH SOURCE_STRING DESTINATION_STRING echo Where: FILE_FULL_PATH is the full path of the file to be replaced in echo SOURCE_STRING is string to be replaced echo DESTINATION_STRING is string to be replaced as pause exit ) if %2%.==. ( echo Usa…
2009-06-09 21:53 · Linux - Miscellaneous
View object source
Oracle select text from user_source DB2 select text from syscat.tables select text from syscat.procedures where procschema= and procname=
2009-06-08 20:41 · Oracle
cpio
Extract cpio -i </home/robert/abc.cpio Package find . -print | cpio -ocv >/home/robert/abc.cpio
2009-06-08 15:31 · Linux - Miscellaneous
nohup
nohup 命令 用途 不挂断地运行命令。 语法 nohup { -p pid | Command [ Arg ... ] [ & ] } 描述 nohup 命令运行由 Command 参数和任何相关的 Arg 参数指定的命令,同时忽略所有的挂起(SIGHUP)信号,或者修改用 -p 选项指定的进程来忽略所有的挂起(SIGHUP)信号。 在注销后还可以使用 nohup 命令运行后台中的程序。要运行后台中的 nohup 命令,添加 & (表示“and”的符号)到命令的尾部。 注: 不能同时指定 -p pid 和 Command。 使用 -p pid 时,指定进程的输出将不会重定向到 nohup…
2009-06-04 00:25 · Linux - Shell
Jave VM memory Arg/Java 虚拟机内存参数
http://winywan.com/index.php/reviews/java-foundation/2009/01/05/94/ JVM参数详解以及配置调优 基本概念: PermGen space:全称是Permanent Generation space。就是说是永久保存的区域,用于存放Class和Meta信息,Class在被Load的时候被放入该区域 Heap space:存放Instance。 GC(Garbage Collection)应该不会对PermGen space进行清理 所以如果你的APP会LOAD很多CLASS的话,就很可能出现PermGen space错误 Jav…
2009-05-22 16:05 · J2SE&J2EE
Weblogic/ADF/Fussion Middleware
http://download.oracle.com/docs/cd/E12839_01/web.1111/b31974/deployment_topics.htm#CIHHFCFF http://e-docs.bea.com/wls/docs81/deployment/tools.html#1000477 http://otnbeta.oracle.com/fmw11g/582tj30eapvb/core.1111/e10043/toc.htm http://otnbeta.oracle.com/fmw11g/582tj30eapvb/core.1111/e10043/cfgauthr.h…
2009-05-22 00:35 · J2SE&J2EE
BufferredOutputStream
BufferredOutputStream is not implemented consistently between Windows and Linux. Take this for an example, BufferredOutputStream bos = new BufferredOutputStream (new FileOutputSteam); bos.write(......); If the bos is not closed explicitly, it doesn't work in Windows, but works well in linux. That i…
2009-05-16 20:08 · J2SE&J2EE
Change the sequence
CREATE SEQUENCE DEMO.S_CUST_ID START WITH 2 MAXVALUE 10000000 MINVALUE 1 CYCLE NOCACHE NOORDER; ALTER SEQUENCE DEMO.S_CUST_ID INCREMENT BY 1 MINVALUE 1 MAXVALUE 10000000 NOCACHE CYCLE NOORDER;
2009-05-08 13:43 · Oracle
How to configure OID Authentication in Weblogic
Oracle WebLogic Server provides a plugable security architecture in which authentication providers handle user identification. One of the native authentication providers in WebLogic server is for a generic LDAP server. Oracle Internet Directory (OID) is a LDAP v3 compliant server and can be configu…
2009-04-28 23:22 · J2SE&J2EE
oid/oim/ldap/jndi API
Reference http://download.oracle.com/docs/cd/B15904_01/manage.1012/b14087/toc.htm OID/OIM is an implementation of JNDI by LDAP.(Actually, it has C API to access it as well.) 1. Put the jar file into the class path. Oracle\Middleware\jdeveloper\modules\oracle.ldap_11.1.1\ldapjclnt11.jar 2. Connectin…
2009-04-28 22:45 · J2SE&J2EE
impdp
impdb loads the dmp file from ORACLE_HOME/admin/ORACLE_SID/dpdump/test.dump, so before we run impdb, we put it into this folder. oracle@laptop-ubuntu:/opt/oracle/admin/orcl/dpdump$ impdp system/manager SCHEMAS=test DUMPFILE=test.dmp TABLE_EXISTS_ACTION=replace LOGFILE=test.log Import: Release 11.1.…
2009-04-27 19:29 · Oracle