Courses
Tutorials
Practice

Similar Topics

Web Technologies37.4K+ articles

DSA22.8K+ articles

Python21.3K+ articles

Experiences16.6K+ articles

Interview Experiences14.1K+ articles

JavaScript12.2K+ articles

School Learning11.5K+ articles

Java10.8K+ articles

Misc8.8K+ articles

Mathematical7.8K+ articles

PL/SQL Query

48 posts

How to Efficiently Convert Rows to Columns in PL/SQL?

Last Updated: 03 November 2024

In Oracle PL/SQL, converting rows into columns is a common operation, especially useful for reporting, data analysis, and reformatting data for easy visualization. PL/SQL,...read more

article_image

How to Write a Simple SELECT Stored Procedure in PL/SQL?

Last Updated: 23 October 2024

In PL/SQL, stored procedures are powerful tools for encapsulating logic and executing complex queries. This article will guide you through the process of creating a simple...read more

article_image

How to Export Schema Without Data in PL/SQL?

Last Updated: 07 November 2024

In database management, there are times when you need to export the structure of your database objects such as tables, views, and procedures without including the data. Th...read more

article_image

Difference Between Views and Materialized Views in PL/SQL

Last Updated: 05 November 2024

In PL/SQL views play an important role in data accessibility, data manipulation, and query optimization. Views help restrict the user's data, which is not supposed to be a...read more

article_image

How to Select Dates Between Two Date Range in PL/SQL

Last Updated: 06 November 2024

In database management, PL/SQL (Procedural Language/Structured Query Language) stands out as a powerful tool for managing data within Oracle databases. When dealing with d...read more

article_image

How to split a delimited string to access individual items in PL/SQL?

Last Updated: 17 October 2024

In PL/SQL, dealing with delimited strings is a common task, especially when handling data from external sources or processing user inputs. One challenge developers face is...read more

article_image

When to Use ON UPDATE CASCADE in PL/SQL?

Last Updated: 24 October 2024

In Oracle PL/SQL, managing the update of related records in child tables can be challenging, especially when dealing with complex data relationships. The ON UPDATE CASCADE...read more

How to Reset Primary Key Sequence in PL/SQL

Last Updated: 05 March 2024

Resetting a PL/SQL primary key sequence is an important task to ensure that the sequence values align with the current state of the table. When a sequence falls out of syn...read more

How to Create a User With Full Privileges in PL/SQL?

Last Updated: 27 February 2024

In database administration, the ability to manage user privileges is very important. As a database administrator, we may find ourselves in the position of creating users w...read more

article_image

How to Declare a Variable in PL/SQL?

Last Updated: 21 October 2024

Declaring variables in PL/SQL is a fundamental step towards building powerful and efficient database applications. Variables act as placeholders for data which enable us t...read more

article_image

How to Select Random Record From Table in PL/SQL?

Last Updated: 03 November 2024

In Oracle PL/SQL, selecting random records from a table is a common yet essential operation, used for a variety of purposes like data sampling, random selection for testin...read more

article_image

PL/SQL Cursor Variable with REF CURSOR

Last Updated: 17 October 2024

In PL/SQL, Cursor variables, also known as REF CURSORs, provide a dynamic and flexible means to handle query results. A cursor variable is a reference to a cursor, which ...read more

How to Retrieve Data From Multiple Tables in PL/SQL?

Last Updated: 16 February 2024

Retrieving data from multiple tables is a common task in PL/SQL and It is a skill that can significantly enhance our data manipulation capabilities. Whether we are joining...read more

How to insert a line break in a String PL/SQL

Last Updated: 23 October 2024

In PL/SQL, inserting line breaks into VARCHAR or NVARCHAR strings can be a good way to enhance the readability and presentation of our data. Whether we are formatting outp...read more

article_image

PL/SQL RAISE Exceptions

Last Updated: 21 October 2024

PL/SQL stands for Procedural Language Extension to the Structured Query Language and it is designed specifically for Oracle databases. It extends Structured Query Language...read more