Database

How to Select Multiple Records in Oracle Apps Forms ( Multi-Select Check Box Tutorial)

In Oracle forms, you would have seen a multi-record block with a checkbox. When you click,  Select all – when the master checkbox is checked then all child checkboxes on the form should be checked. Unselect All – when the master checkbox is unchecked then all child checkboxes on the form should be unchecked. This …

How to Select Multiple Records in Oracle Apps Forms ( Multi-Select Check Box Tutorial) Read More »

How to schedule Concurrent Program/Request in Oracle Apps

Oracle apps provide built-in functionality to schedule concurrent programs so that they run at specified times and intervals. This leads to effective utilisation of hardware, software, and human resources. Concurrent Program is one of the most important functionalities available in Oracle Apps. It allows users to submit jobs parallelly. These programs run in the background …

How to schedule Concurrent Program/Request in Oracle Apps Read More »

Pre-Built Developer VMs (for Oracle VM VirtualBox) – learn Oracle Database, Linux, SOA, APEX

Pre-Built Developer VMs (for Oracle VM VirtualBox) helps you to import pre-built and ready to use development virtual machines directly to Virtualbox. No need to install an operating system or any other software except, you need Virtualbox Installed on your desktop. There are VMs available for Oracle Database, APEX, SOA Suite, Linux, Solaris and other …

Pre-Built Developer VMs (for Oracle VM VirtualBox) – learn Oracle Database, Linux, SOA, APEX Read More »

How efficient is PL/SQL Bulk Processing? Does it really help…….

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 code is executed by PL/SQL Engine while SQL by SQL Engine. You will never notice any lag as  Oracle database manages this engine switch very efficiently This is fine for …

How efficient is PL/SQL Bulk Processing? Does it really help……. Read More »

How to Submit Concurrent Program from back-end using fnd_request 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 fnd_request.submit_request  API. This function submits a concurrent request for processing by concurrent Manager and returns, request id – if the request is submitted successfully 0 – if the request is not …

How to Submit Concurrent Program from back-end using fnd_request in Oracle Apps Read More »

ABS function in Oracle SQL

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 10 which is an absolute value. This function also works on the decimal. Syntax ABS(N) N – input parameter SELECT ABS(-10)FROM DUAL; Absolute ———- 10