Database

How to Install SQL Developer on Linux (Red Hat, Fedora, Oracle, Centos, Rocky Linux)

SQL Developer is a free and integrated development tool that you can use to develop and manage Oracle Database. It even works with cloud databases as well. This tool offers all the features developers need to design, develop, and debug PL/SQL applications. Below are some of the core features of this tool, Supports Oracle Database, …

How to Install SQL Developer on Linux (Red Hat, Fedora, Oracle, Centos, Rocky Linux) Read More »

How to download Software/Tools from Oracle Site for Free

Oracle provides most of the developer tools free to use for learning and education purposes. You only need Oracle Account to download this software. So in this article, let’s see how to download software from Oracle. Note:- You can not use these software for commercial purposes. Software/Tools by Oracle Oracle Corporation, a multinational computer technology company …

How to download Software/Tools from Oracle Site for Free Read More »

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 »

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 »