Skip to content
Courses
DSA to Development
Get IBM Certification
Newly Launched!
Master Django Framework
Become AWS Certified
For Working Professionals
Interview 101: DSA & System Design
Data Science Training Program
JAVA Backend Development (Live)
DevOps Engineering (LIVE)
Data Structures & Algorithms in Python
For Students
Placement Preparation Course
Data Science (Live)
Data Structure & Algorithm-Self Paced (C++/JAVA)
Master Competitive Programming (Live)
Full Stack Development with React & Node JS (Live)
Full Stack Development
Data Science Program
All Courses
Tutorials
Data Structures & Algorithms
ML & Data Science
Interview Corner
Programming Languages
Web Development
CS Subjects
DevOps And Linux
School Learning
Practice
GfG 160: Daily DSA
Problem of the Day
Practice Coding Problems
GfG SDE Sheet
DSA
Practice Problems
C
C++
Java
Python
JavaScript
Data Science
Machine Learning
Courses
Linux
DevOps
SQL
Web Development
System Design
Aptitude
GfG Premium
Sign In
▲
Similar Topics
Web Technologies
38.9k+ articles
DSA
22.5k+ articles
Python
20.4k+ articles
Experiences
16.5k+ articles
Interview Experiences
14.1k+ articles
JavaScript
11.7k+ articles
School Learning
11.3k+ articles
Java
10.5k+ articles
Databases
2.2k+ articles
PL/SQL
170+ articles
PL/SQL Query
48 posts
Popular Articles
Recent Articles
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
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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 st
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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 t
...read more
Picked
Databases
PL/SQL
PL/SQL Query
Similar Topics
Web Technologies
38.9k+ articles
DSA
22.5k+ articles
Python
20.4k+ articles
Experiences
16.5k+ articles
Interview Experiences
14.1k+ articles
JavaScript
11.7k+ articles
School Learning
11.3k+ articles
Java
10.5k+ articles
Databases
2.2k+ articles
PL/SQL
170+ articles
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
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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 t
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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. O
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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 relat
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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 placehol
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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.
...read more
Picked
Databases
PL/SQL
PL/SQL Query
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 ex
...read more
Picked
Databases
PL/SQL
PL/SQL Query
How to Update Multiple Rows at Once Using PL/SQL?
Last Updated: 28 October 2024
Updating multiple rows simultaneously is a common requirement in database management, especially when handling large datasets. PL/SQL, the p
...read more
Picked
Databases
PL/SQL
PL/SQL Query
Index in PL/SQL
Last Updated: 23 October 2024
PL/SQL, Oracle's extension to SQL, combines SQL with procedural programming features like loops, conditionals, and exception handling. It en
...read more
Picked
Databases
PL/SQL
PL/SQL Query
How to Insert Multiple Rows at Once in PL/SQL?
Last Updated: 23 October 2024
As the volume and complexity of data continue to grow in modern systems, efficient data management techniques become important. One fundamen
...read more
Picked
Geeks Premier League
Geeks Premier League 2023
Databases
PL/SQL
PL/SQL Query
How to Set a Column Value to Null in PL/SQL?
Last Updated: 28 October 2024
In PL/SQL, setting a column value to NULL is a common requirement when working with databases. Understanding how to set column values to NUL
...read more
Picked
Databases
PL/SQL
PL/SQL Query
1
2
3
4
>>
Last
1
2
3
4
>>
Last
1
2
3
4
>>
Last
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our
Cookie Policy
&
Privacy Policy
Got It !