Oracle Workflow APIs: 1 WF_ENGINE2 WF_CORE3 WF_PURGE4 WF_DIRECTORY5 WF_PREF6 WF_MONITOR7 Oracle Workflow Views8 WF_QUEUE9 FND_DOCUMENT_MANAGEMENT10 WF_NOTIFICATIONS WF_ENGINE APIs: The Workflow Engine APIs can be called by an application program or a workflow function in the runtime phase to communicate with the engine and to change the status of each of the activities. These APIs aredefined […]
How to Kill the session when there is a lock on the objects you are working in TOAD or Sqlplus select * from V$SESSION where OSUSER like ‘c_sgoud’ — User name of the terminal ( may be your windows login name ) Alter system kill session ‘146,46619’ select sid, serial# from v$session where username = […]
Lot of time we got this type of senerio When working with nulls, you can avoid some common mistakes by keeping in mind the following rules: Comparisons involving nulls always yield NULL Applying the logical operator NOT to a null yields NULL In conditional control statements, if the condition yields NULL, its associated sequence of […]
Decode1.It’s a function2.can compare only discrete vaules3.Pl/Sql standards4.cannot process null Case1.It’s an Expression2.can hande range values3.ANSI Standards4.Processing time is faster when compared to Decode5.can process null DecodeThe default operator for comparison is ‘=’,for e.g select deptno,decode(deptno,10,’dept10′,20,dept20,default) so if the deptno=10 then the value is replaced by dept10 and so on, whereas in Case: we can […]
Components of Oracle Workflow : Workflow BuilderWorkflow EngineWorkflow Definitions LoaderNotification SystemsWorkflow MonitorNotification systemsBusiness Event System’sWorkflow XML LoaderDirectory Service’s.Workflow Builder :Work Flow builder is a Graphical interface to create and modify a business process with simple drag and drop operations.It has two components –* Navigator Window* Process WindowA workflow builder would be used by a person […]
Recent Comments