Oracle Listagg function helps to concatenate multiple rows into a single string. This article explains this in details. Once a developer asked, “How to combine… Read More »Combine multiple rows into a single string in Oracle
Oracle Application Express is Web Application Development Tool. It enables you to design, develop and deploy beautiful, responsive, database-driven applications using only your web browser.… Read More »Download Oracle Application Express (APEX) [All Version Links]
Oracle Reports is an enterprise reporting tool. You can generate reports in any popular format for web and paper, burst, and distribute reports to any… Read More »Oracle Reports (RDF) Concurrent Program in Oracle Apps
SQL* Plus is one of the executable methods available while defining a concurrent program in Oracle Apps. It allows running SQL* Plus script against the… Read More »SQL* Plus Concurrent Program in Oracle Apps
PL/SQL is procedural language extension for SQL. It has it’s own commands, datatype, operator, etc. You can use SQL statements within PL/SQL code. Here, PL/SQL… Read More »How efficient is PL/SQL Bulk Processing? Does it really help…….
Business users sometimes need functionality to email the output of the concurrent program as soon as it completes. Let’s see how to email concurrent request… Read More »Email Concurrent Request Output in Oracle Apps
fnd_request.submit_request Oracle Apps PL/SQL API helps to submit the concurrent program from the backend. backend means from the Database. fnd_request.submit_request Below is the signature of… Read More »How to Submit Concurrent Program from back-end using fnd_request in Oracle Apps
How to make Parent concurrent request to wait until all child concurrent programs complete in Oracle Apps? So what we are looking at here is… Read More »Parent Child concurrent request in Oracle Apps
ABS function in Oracle SQL returns the absolute value. Let’s assume a number -10 when you run the abs function of this number it returns… Read More »ABS function in Oracle SQL
In the last article, we discussed how to define and schedule ESS Jobs in Oracle Fusion. Wondering which tables stores these ESS Job definition? Let’s… Read More »ESS Job Definition tables in Oracle Fusion