Tutorials
Courses

Similar Topics

Web Technologies37.4K+ articles

DSA21.3K+ articles

Python21.3K+ articles

Experiences16.6K+ articles

Interview Experiences14.2K+ articles

JavaScript12.1K+ articles

School Learning11.5K+ articles

Java10.0K+ articles

Misc8.5K+ articles

Mathematical7.6K+ articles

PL/SQL Query

48 posts

How to Retrieve Data From Multiple Tables Using PL/SQL Cursors

Last Updated: 19 March 2024

In database programming, the ability to retrieve data from multiple tables is essential for building robust and efficient applications. PL/SQL Cursors is a powerful featur...read more

article_image

How to Use LISTAGG Function to Concatenate Strings in PL/SQL?

Last Updated: 29 October 2024

In PL/SQL, concatenating strings from multiple rows into a single value is a common requirement. The LISTAGG function offers a convenient solution for this task, allowing ...read more

article_image

PL/SQL Package Specification

Last Updated: 26 March 2024

PL/SQL ( Procedural Language/Structural Query Language ) is the extension of SQL ( Structured Query Language ) which is allowed to the developers for creating the procedur...read more

article_image

How to Retrieve Column Data Type in Oracle Using PL/SQL

Last Updated: 21 October 2024

In Oracle databases, understanding column data types is essential for effective database management. PL/SQL provides a straightforward way to retrieve these data types, ai...read more

article_image

How to Update Table Rows in PL/SQL Using Subquery?

Last Updated: 26 March 2024

Updating table rows in PL/SQL via subqueries allows precise data modifications based on specific conditions. By integrating subqueries within the UPDATE statement, rows ca...read more

article_image

How to Pagination in PL/SQL?

Last Updated: 26 March 2024

Pagination is a technique used to divide large datasets into smaller, manageable chunks called pages. It's important for improving user experience and optimizing database ...read more

article_image

How to Get PL/SQL Database Size?

Last Updated: 19 March 2024

In PL/SQL Databases, sometimes you need to know the database size to manage its performance and plan for the future. Retrieving database size information helps us make i...read more

article_image

How to Get Multiple Counts With Single Query in PL/SQL?

Last Updated: 18 March 2024

In PL/SQL, it's very common that we need to count rows based on the different conditions in the single query. This can be done using conditional aggregation or we also do ...read more

article_image

How to Restrict Results to top N Rows per Group in PL/SQL?

Last Updated: 19 March 2024

In the world of database administration, retrieving top N rows from every grouping is a frequent but complicated one. Whether you are performing cross-tabulations with lar...read more

article_image

How to Get the Day of the Week for PL/SQL?

Last Updated: 28 October 2024

PL/SQL is a Procedural language extension for the Structured Query Language (SQL) that allows for procedural programming in Oracle databases. This language can create tabl...read more

article_image

How to Create id With AUTO_INCREMENT in PL/SQL?

Last Updated: 11 November 2024

PL/SQL, short for Procedural Language/Structured Query Language, combines SQL capabilities with procedural programming. It supports variable declaration, control flow stru...read more

article_image

How to Get the Top 10 Values in PL/SQL?

Last Updated: 28 October 2024

PL/SQL stands for Procedural Language/ Structured Query Language. It has block structure programming features. PL/SQL supports SQL queries. PL/SQL contains a declaration s...read more

article_image

PL/SQL Statement level Triggers

Last Updated: 21 October 2024

Statement-level triggers in Oracle databases execute actions for each transaction, responding to various database events like DML and DDL statements, system events, and us...read more

article_image

How to Rename a Column in PL/SQL?

Last Updated: 28 October 2024

Renaming a column in PL/SQL is a fundamental operation in Oracle Database management. It enhances clarity, maintains consistency, or accommodates evolving data requirement...read more

article_image

PL/SQL Query to List the Last 25% Rows in a Result Set

Last Updated: 16 April 2024

We sometimes need to fetch some specific rows from our result set. There are many reasons to do so. When we are working on real-time analytics, focusing on recent data is ...read more