The main query expects the sub query to return only one value.Check out the following example, which should look familiar:SQL> select ename, deptno, sal 2 from emp 3 where deptno = 4 ( select deptno 5 from dept 6 where loc = ‘NEW YORK’ );ENAME DEPTNO SAL———- ——— ———CLARK 10 […]
Subquery or Inner query or Nested query is a query in a query. A subquery is usually added in the WHERE Clause of the sql statement. Most of the time, a subquery is used when you know how to search for a value using a SELECT statement, but do not know the exact value. select ename, […]
The Oracle applications that use Oracle Installed Base are shown the picture.Several Oracle Order Management, Purchasing, Inventory, Work in process transactions interact with Oracle Installed Base. Oracle Installed Base can track both shippable and non-shippable items.Purcahse OrderIn case of purchase orders when the receipt of materials is completed, system increases the Inventory on hand. If […]
Oracle Installed Base can track an item instance from the time that it is received in inventory, in work in process, in projects, at customer sites, and throughout the return and repair process. Item Instance Attribute Change TrackingOracle Installed Base is a centralized repository of information for an item instance and its tracking details including […]
All All the functionalities of installed base module can be accessed with Installed Base User responsibility. And to access the’ Installed Base User’ responsibility’ the user must be assigned to CSI_NORMAL_USER role. Follow the below setups to assign the required roles to Installed Base Users 1. Login to the instance with sysadmin user and select […]
Recent Comments