DUP_VAL_ON_INDEX Exception in PL/SQL
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… Read More »DUP_VAL_ON_INDEX Exception in PL/SQL
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… Read More »DUP_VAL_ON_INDEX Exception in PL/SQL
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… Read More »How to Install SQL Developer on Linux (Red Hat, Fedora, Oracle, Centos, Rocky Linux)
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… Read More »How to create Oracle Account (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… Read More »How to download Software/Tools from Oracle Site for Free
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… Read More »How to Select Multiple Records in Oracle Apps Forms ( Multi-Select Check Box Tutorial)
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… Read More »What is meaning of i, g and c in Oracle Database Version
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… Read More »Pre-Built Developer VMs (for Oracle VM VirtualBox) – learn Oracle Database, Linux, SOA, APEX
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
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…….
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