Database

Data definition and templates are the main backbone of XML Publisher reports in Oracle Apps. Each data and template definition is unique. Once defined, you can not use the same name/code for others. First, you define the data definition and then the template. So, when you want to delete, you need to follow the reverse […]

DUP_VAL_ON_INDEX is a pre-defined exception in PL/SQL which is raised when a program attempts to store duplicate values in a database column that is constrained by a unique index. The name itself explains what this exception is all about. Duplicate Value on Index column The main reasons for the DUP_VAL_ON_INDEX exception are: Unique Index Constraint: When a

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. This is a cross-platform application which means it is available for Windows, macOS,

A free Oracle Account lets you download tools, sign in to applications,  communities, and more. This is very useful for developers and students who want to learn Oracle software like database, Jdeveloper, SQL Developer, etc. You can download software, and seek help from Oracle communities. Open create your Oracle Account page. Enter all necessary details on

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 headquartered

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

Oracle DBAs and Developers .. ever wondered the meaning of i, g and c in Oracle Database Releases version starting from 8 onwards? No.. right. Let me explain the meaning of i, g and c. Larry Ellison, Bob Miner, Ed Oates and Bruce Scott founded Oracle in 1977 with an initial name as Project Oracle. Later

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

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 multiple rows into a single string delimited by comma, or pipe?” The requirement is to get email id from a table, concatenate those by “,” and use it as a parameter while

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