聚集索引与非聚集索引的区别
聚集索引和非聚集索引的根本区别是表记录的排列顺序和与索引的排列顺序是否一致,聚集索引表记录的排列顺序与索引的排列顺序一致,优点是查询速度快,因为一旦具有第一个索引值的纪录被找到,具有连续索引值的记录...
linux shell编程if语句内判断参数
shell 编程中使用到得if语句内判断参数 –b 当file存在并且是块文件时返回真 -c 当file存在并且是字符文件时返回真 -d 当pathname存在并且是一个目录时返回真 -e 当pathname指定的文件或目录存在时...
Linux下修改IP地址
Linux系统下如何设置IP地址?我们可以通过命令设定IP的方法,不过此方法的前提条件是用户需root权限。在linux系统的 /etc/sysconfig/network-script/ifcfg-eth0文件中存放着网卡IP地址配置的相关信息,它的具体格式...
查看局域网中IP被谁占用了
1.nbtstat -a <ip> 2.ping -a <ip>
Why Isn't Oracle Using My Index?!
转自http://www.dbazine.com/oracle/or-articles/jlewis12我用10g测试,都走索引了,不知道9i是不是向以下说的这样Why Isn't Oracle Using My Index?!by Jonathan Lewis ...
tkprof使用语法
tkprof trace_fileoutput_file [ explain=userid/password@database ]
killing my session in oracle
转自http://www.orafaq.com/files/KillingMySessions_1.txt KILLING MY SESSIONS IN ORACLEAuthor JP VijaykumarDate Nov 14th 2009Many a time, developers ask for procedures to kill there own s...
use Sun's JRE/JDK 1.6 Parameter to Specify a Particular JRE with Multiple
How to use Sun's JRE/JDK 1.6.0_10java_version Parameter to Specify a Particular JRE with MultipleVersions on a PC [ID 758823.1]Applies to: Oracle Forms - Version: 10.1.2.3.0 to 10.1.2.3.0Informati...
一些关于JRE和webutil的链接地址
各个版本的JRE的下载地址:http://java.sun.com/javase/6/docs/technotes/guides/deployment/deployment-guide/autodl-files.htmlApplication Server和Form. Builder 10通过论证的JRE和浏览器:http://www.oracle.com/...
Event-Driven Publishing using Database Trigger in Reports 9i/10g [ID 199743.1]
PURPOSE-------Demonstrate the Event-based publishing feature of Reports 9i/10G/10G R2 using a database trigger.NOTE: Please see on OTN, "Oracle® Application Server ReportsServices Publishing Repo...
解决在Form表单中光标移动不了问题
apply p8727236_10123 for Developer Suite 10.1.2.3 in Linux首先到oracle的技术支持下载所需补丁,然后1先打补丁7121788,把p7121788_10123_LINUX.zip解压到/home/oracledev目录下(ORACLE_HOME为/u01/app/o...
oracle 正规表达式
转自 http://www.psoug.org/reference/regexp.htmlGeneral InformationAnchoring Characters Character Class Description^ Anchor the expression to th...
转 Oracle SQL性能优化
转自: http://space.itpub.net/21229923/viewspace-6203491. 选用适合的ORACLE优化器 ORACLE的优化器共有3种:a.RULE(基于规则) b.COST(基于成本) c.CHOOSE(选择性) 设置缺省的...
webutil在Linux下Oracle Application Server的安装和测试
分别下载webutil 1.6,Webutil Demo和jacob 18 http://www.oracle.com/technology/software/products/forms/files/webutil/webutil_106.zip http://www.oracle.com/technology/products/forms/htdocs/w...
Kickstarting WebUtil 1.06 in Developer Suite 10.1.2.0.2 on Windows [ID 333385.1]
Applies to: Oracle Forms - Version: 1.0.6Microsoft Windows (32-bit)GoalHow to get up and running with WebUtil 1.06 included with Oracle Developer Suite 10.1.2.0.2 on a win32 platform.SolutionAssumi...
How To Install Webutil on 10.1.2.x Oracle AS on Windows ? [ID 566628.1]
Applies to: Oracle Forms - Version: 10.1.2MS WindowsMicrosoft Windows GoalHow to install WebUtil on 10.1.2.x OAS on Windows ?Solution1)- Download Webutil files from the following link: - Webut...
How To Install Webutil on OAS under Linux/Unix [ID 374128.1]
Applies to: Oracle Forms - Version: 10.1.2.0.2Linux x86GoalHow to Install Webutil on Oracle AS 10.1.2.0.2 under Linux/Unix ?SolutionINSTALLATION -------------------------- 0. Linux and vers...
关于Linux下compile的错误FRM-91500解决方法
Linux下编译pll,fmb和mmb时报错[oracleas@tuning forms]$ frmcmp_batch.sh module=WU_TEST_106.fmb userid=webutil/webutil@tuning compile_all=yes module_type=formFRM-91500: Unable to start/complete the buil...
webutil的使用
Subject:Webutil functionalities fail witherror like: "Oracle.forms.webutil.host.Host bean not found.WeBUTIL_HOST.Execute will not work" Doc ID:469183.1Type: PROBLEM Modified Da...
查看表空间使用率SQL语句
spool /home/oracle/tablespace.sql SELECT file_name, tablespace_name, bytes/(1024*1024) bytes1, autoextensible, maxbytes/(1024*1024) maxbytes1, user_bytes/(1024*1024) user_bytes1 FROM dba_data_f...