);
1.静态SQL与动态SQL
Ora...
原创
2023-04-19 03:10:53
155阅读
This article explains how to use the JRuby programming language with Oracle Database 11g Release 2. JRuby allows the Java platform and extensive libraries to be augmented with an easy to use and powerful scripting language.Software RequirementsThe following software can be used:Oracle Database 11g R
转载
2011-03-08 13:29:00
121阅读
Q:When will you use raw devices in ASM?A: 1.There's no approximate asmlib for kernel of your host 2.You wanna promote I/O performance of database under your estimation compar
原创
2014-04-16 23:11:45
1070阅读
--目标表，更新或者插入此表merge into emp2 a using (select * from emp) b --匹配条件 on (a.empno = b.empno) --匹配时更新目标表 when matched then update set a.sal = b.sal --不匹配时插入到目标表 when not matched
原创
2021-09-13 09:14:19
1901阅读
Understanding and Using HRMS Security in Oracle HRMS Product:Oracle Human Resources Minimum Version:11.5.9 An Oracle White Paper Abstract Under...
转载
2014-10-23 15:27:00
222阅读
点赞
1评论
FROM:http://blog.csdn.net/pan_tian/article/details/10159935 Oracle EBS如何与第三方系统相集成？比如这样的需求，X系统知道物料编码，需要从EBS系统里读取具体物料信息，或者X系统想把自己的人员信息同步到EBS，这类集成...
转载
2014-11-11 17:41:00
205阅读
2评论
How to Delete Archivelog Using RMAN in Oracle Recovery Manager (RMAN) is an Oracle Database client that performs backup and recovery tasks on your dat
转载
2019-08-17 17:00:00
105阅读
2评论
The full list of Oracle parallel execution features currently includes the following
Parallel Query
Parallel DML
Parallel DDL
Parallel Data Loading
Parallel Recovery
Para
原创
2022-01-04 14:09:47
75阅读
变化数据随时都可能生成，因此需要不断的将新的变化同步过去。有两种方法可以完成这个任务。第一种办法可以通过计划实现。例如创建一个计划，每半个小时执行一次同步接口。这样可以每半个小时将变化数据同步到目标。此法需要注意计划的重复间隔，要保证在重复调用之前，上一次调用已经完成，一般可以用于定期同步的需求。第二种办法是在创建一个包，利用ODI提供的CDC相关的工具轮询日记，一旦有了变化就调用同步接口。此法可
原创
2018-03-02 10:35:10
993阅读
本文介绍如何部署一个带有adg功能的shardeddatabase。1、环境介绍各个节点的角色以及数据库版本如下表所示：其中实例名是系统自己命名的。2、创建ShardCatalogDatabase这里使用静默方式在odb01上创建目录数据库。[oracle@odb01~]$vi/tmp/dbca.rspresponseFileVersion=/oracle/assistants/rspfmt_db
原创
2019-07-16 17:23:25
1152阅读
推进使用自动管理 automatic segment1 个 Blocks = 2的幂次方倍tablespace 像一块地segment 像一个房子extents 向一个装砖头的框blocks 像砖头segment 一次性最少要分配一个 extents推荐使用 UNIFORM 在创建 extent 时.grant connect, resource to mark;create table t(id int, name char(10));注意, 执行第一个命令时无法得到empty blocks 的数值, 需要执行 analyze table t compute statistics 才能得到
转载
2014-04-05 16:37:00
93阅读
2评论
Oracle has recently disallowed direct downloads of java from their servers (without going through the browser and agreeing to their terms, which you can look at here:http://www.oracle.com/technetwork/
转载
精选
2012-12-17 16:16:22
853阅读
个人学习仅供参考！！！
原创
2019-10-15 16:15:55
2637阅读
Post-Form trigger in Oracle Forms fires during the Leave the Form process, when a form is exited. You can use Post-Form trigger for the tasks such as: To clean up the form before exiting. For examp...
原创
2021-07-21 11:29:49
1131阅读
If the mouse is in an item, SYSTEM.MOUSE_ITEM represents the name of that item as a CHAR value.For example, if the mouse is in Item1 in Block2, the value for SYSTEM.MOUSE_ITEM is :BLOCK2.ITEM1.SYSTEM....
原创
2021-07-21 11:29:53
515阅读
If the mouse is in an item, SYSTEM.MOUSE_ITEM represents the name of that item as a CHAR value.For example, if the mouse is in Item1 in Block2, the
原创
2021-07-21 11:30:11
420阅读
When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for each record placed on the block’s list of records. Usag...
原创
2021-07-21 11:34:04
388阅读
什么情况下Oracle Clusterware会重启（Evict，驱逐）节点机器？ 1. 节点机器在interconnect network上无法ping通，没有了network heartbeat，比如网络问题。 2. 节点机器无法存取Voting Disk，没有了disk heartbeat，比如磁盘问题。 3. 由于节点机器过于繁忙，导致没有空闲资源
转载
精选
2012-11-01 16:46:45
620阅读
https://access.redhat.com/solutions/302753SOLUTION 已验证- 已更新2013年二月2日00:58-English环境Red Hat Enterprise Linux 5问题How can we verify at the OS-level whether Oracle is allowed and configur...
转载
2021-10-25 15:07:54
80阅读
Pre-Form trigger in Oracle Forms fires during the form start-up, before forms navigates to the first navigable data block of that form. Use a Pre-Form trigger to perform the tasks such as maximize t...
原创
2021-07-21 11:29:49
700阅读
