Tutorials
Courses

Similar Topics

Web Technologies37.4K+ articles

Misc8.7K+ articles

DBMS1.6K+ articles

SQL1.5K+ articles

MongoDB737+ articles

DBMS-SQL527+ articles

PostgreSQL394+ articles

mysql330+ articles

SQL-Server319+ articles

MongoDB183+ articles

Databases / PL/SQL

PL/SQL

183+ posts

PL/SQL UPDATE Statement

Last Updated: 03 October 2024

The UPDATE statement in the PL/SQL(Procedural Language/ Structural Query Language) is the powerful SQL (Structured Query Language) command used to modify the existing data...read more

Fixing Mutating Table Error in PL/SQL

Last Updated: 11 October 2024

In PL/SQL, themutating table erroroccurs when a trigger tries to modify a table that is already being modified by the statement that caused the trigger to fire. This restr...read more

PL/SQL Partition

Last Updated: 11 October 2024

In PL/SQL, partitioning is a powerful feature that helps divide large tables, indexes, and other database objects into smaller, more manageable segments called partitions....read more

Statistical Functions in PL/SQL

Last Updated: 11 October 2024

PL/SQLprovides powerful statistical functions to perform various statistical calculations directly within the Oracle database. It provides a rich set of statistical functi...read more

PL/SQL MIN() Function

Last Updated: 11 October 2024

PL/SQL means Procedural Language / relational Structured Query Language, the extended language of Oracle. It is primarily used to manage and manipulate databases. One of t...read more

article_image

Last Updated: 09 October 2024

JOIN is a powerful operation in PL/SQL that allows us to combine data from two or more related tables based on a common key. The PL/SQL JOIN is used to select data from mu...read more

article_image

PL/SQL MAX() Function

Last Updated: 09 October 2024

The PL/SQL MAX() function is an essential aggregate function in Oracle databases, enabling users to efficiently determine the largest value in a dataset. Whether working w...read more

PL/SQL Insert Dates

Last Updated: 01 November 2024

When managing databases, handling date and time data accurately is important. Date fields are frequently used for storing important information such as user birth dates, p...read more

article_image

Exception Propagation in PL/SQL

Last Updated: 15 October 2024

In PL/SQL (Procedural Language/Structured Query Language), efficient error management is crucial for ensuring smooth execution and robustness in database applications. One...read more

PL/SQL Drop Triggers

Last Updated: 16 October 2024

In database management, triggers play an important role in maintaining data integrity and enforcing business rules automatically. However, there may be situations where we...read more

PL/SQL Associative Array

Last Updated: 16 October 2024

In PL/SQL, anAssociative Array(also known as anindex-by table) is a collection of key-value pairs where each key is unique, allowing for efficient retrieval of the associa...read more

PL/SQL Derived Tables

Last Updated: 15 October 2024

Derived Tablesin PL/SQL are temporary result sets that are created within the execution of a SQL statement. These are essential tools that allow developers to create tempo...read more

PL/SQL Unique Index

Last Updated: 16 October 2024

A PL/SQL Unique Index is a powerful database object used to ensure the uniqueness of values in one or more columns of a table. In Oracle databases, indexes play an importa...read more

PL/SQL EXISTS Operator

Last Updated: 15 October 2024

The EXISTS operator in PL/SQL is a powerful tool used to check the existence of records in a subquery. Unlike traditional comparison operators that evaluate data values, E...read more

PL/SQL Aggregate Function

Last Updated: 24 October 2024

In PL/SQL, aggregate functions play an important role in summarizing and analyzing data from large datasets. These built-in SQL functions perform calculations on a set of ...read more

...