Concurrent Programs can be submitted from the backend ie. database using fnd_request.submit_request.We will check in this post the various code on How to submit a concurrent program from the backend Here is the Snippet of the API FUNCTION fnd_request.submit_request ( application IN VARCHAR2 DEFAULT NULL, program IN VARCHAR2 DEFAULT NULL, description IN VARCHAR2 DEFAULT NULL, […]
how to submit workflow background process from backend
Workflow is an important part of Oracle Ebiz Applications In this post, we will check out what is Workflow Background Engine, How to run Workflow Background Process from Unix, How to run Workflow Background Process using SQLPLUS, how to submit workflow background process from backend What is Workflow Background Engine The Background Engine is a […]
How to use Oracle LISTAGG Function
This is part of Oracle SQL tutorial and has good examples, explanation on Oracle LISTAGG Function. Oracle LISTAGG function Oracle LISTAGG function is an analytical function which allows us to concatenate the strings for measure_column for each GROUP based on the order_by_clause. This is present in Oracle from 11gR2 The syntax for the LISTAGG function in Oracle […]
Regexp in oracle : functions ,Regular expression
This is part of Oracle SQL tutorial and has good examples, explanation on Regexp in oracle. regexp in oracle String manipulation and searching contribute to a large percentage of the logic within a Web-based application. Regular expressions are a method of describing both simple and complex patterns for searching and manipulating. Usage ranges from the simple (“Find […]
How to use Analytic functions in oracle (Over Partition by Keyword)
This post is part of Oracle SQL tutorial and we would be discussing Analytic functions in oracle(Over by partition) with examples, detailed explanation . Analytic functions in oracle We have already studied about Oracle Aggregate function like avg ,sum ,count. Lets take an example First lets create the sample data CREATE TABLE “DEPT” ( “DEPTNO” […]
Top 46 Oracle ASM Interview Questions
Oracle ASM is widely used in the IT industry. Here I have compiled the Top 46 Oracle ASM Interview Questions to enhance my knowledge about Oracle ASM instances. This is good for basic and experienced levels. we have provided the advanced level also in it Basic Level Oracle ASM Interview Questions Question 1 What is ASM […]
