-
编辑 删除
EBS Table Information
EBS Table Information_all，基表，保存多组织数据，里面有一个Org_Id字段，一般不直接出现在我们的DML中去掉_all的视图，根据用户环境过滤掉组织，相当于普通的基表，我们直接使用它，就当它是基表_v，视图，给For...
-
编辑 删除
有关"SELECT FOR UPDATE"的一些概念
statement: 一个SQL语句。session: 一个由ORACLE用户产生的连接，一个用户可以产生多个SESSION ，但相互之间是独立的。transaction:所有的改变都可以划分到transaction里，一个 transaction包含一个或多个SQL。...
-
编辑 删除
PL/SQL 使用集合操作 (union, intersect, minus)
使用集合操作UNION select employee_id,job_id from employeesunionselect employee_id,job_id from job_history;两个表的并集，但不显示重复行。执行的时候要先排序再剔重，所以结果集是有序的。union all也...
-
编辑 删除
PL/SQL 索引 Index
索引： 一个方案中的对象；被ORACLE服务器用来加速对表的查询；通过使用快速路径访问方法快速定位数据；与表独立存放；被ORACLE服务器使用和维护。一定是 WHERE 条件的才有可能使用索引。手动创建索引:CREATE IN...
-
编辑 删除
PL/SQL 序列 Sequence
序列：自动产生的唯一值；一个共享的对象；典型的用法是作为主键的值；insert into 给主键提供值。替代了应用的代码；通过将序列CACHE（预先生成一部分序列号，放入到内存中）到内存中，可以加速对序列的访问...
-
编辑 删除
解禁Oracle 10g的scott用户
倘若用scott用户连接oracle数据库时，提示 error： the account is locked说明scott用户未被解禁。解决办法：以system用户登入，然后输入SQL> alter user scott account unlock;User altered这样就可以以scot...
-
编辑 删除
Oracle中Forms与Reports的集成
Oracle产品Developer 2000中包括多种开发工具，其中在具体工作时用得最多的是Forms和Reports。Forms是一个设计表单的工具，利用它可以灵活方便地定义各种表单对象，以简化用户在运行期对相关数据库的操作（查询...
-
编辑 删除
Oracle Forms Builder
Oracle Forms Builder
-
编辑 删除
Oracle Forms documents
Oracle Forms documents
-
编辑 删除
Oracle Order Management - Add Customer
Oracle Order Management - Add Customer
-
编辑 删除
Oracle® Receivables API User Notes Release 11i
Oracle® ReceivablesAPI User Notes Release 11i
-
编辑 删除
Oracle Order Management - Sales Order Overview
Applies to: Oracle Order Management - Version: 11.5.7 to 11.5.10Information in this document applies to any platform.Abstract:The Sales Order is modeled as a business object comprised of the follo...
-
编辑 删除
How To Import A Sales Order With One Line In Booked Status
Applies to: Oracle Purchasing - Version: 11.5.10 to 12.0.6 - Release: 11.5 to 12Information in this document applies to any platform.Goal:How to Import the Requisition ordered by Line Num...
-
编辑 删除
How To Import Standard PO Using the Purchase Document Open Interface
Vision Demo - How To Import Standard Purchase Orders Using the Purchase Document Open Interface.Check the follow link() for more detail:https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(...
-
编辑 删除
Deep Drive : Customer Interface in AR
Check follow link for the detial:http://www.oracleappshub.com/accounts-receivable/deep-drive-customer-interface-in-ar/Lot of people requested some more information for customer import. So I decided ...
-
编辑 删除
Technical Uses of Customer Interface and TCA-API
Technical Uses of Customer Interface and TCA-API [ID 269121.1] Modified 19-AUG-2009 Type WHITE PAPER Status PUBLISHED&n...
-
编辑 删除
CUSTOMER INTERFACE STATUS ERROR CODES
CUSTOMER INTERFACE STATUS ERROR CODES [ID 1073634.6] Modified 08-DEC-2008 Type PROBLEM Status PUBLISHED Checked f...
-
编辑 删除
How To Add A Contact At Address Level With Phone Via Customer Interface
Problem : How To Add A Contact At Address Level With Phone Via Customer InterfaceModified 06-DEC-2008 Type PROBLEM Status PUBLISHED &n...
-
编辑 删除
How To Add A Contact At Customer Level With Phone Via Customer Interface
How To Add A Contact At Customer Level With Phone Via Customer Interface [ID 176858.1] Modified 19-NOV-2008 Type PROBLEM &...
-
编辑 删除
How To Add A Phone At Address Level Via Customer Interface
Problem : How To Add A Phone At Address Level Via Customer InterfaceModified 19-NOV-2008 Type PROBLEM Status PUBLISHED Checked...
