Last updated: Mar 28, 2022

PL/SQL

In this category, we will be introducing the PLSQL, what it is? How to set up PLSQL in your system and get started with it and don't forget your first database in it. Starting with variables, conditional statements, iterative statements, continue, exit, go Label, stored procedures, and Cursors in PLSQL, we will be set wise taking individual time and looking up at these concepts and then working with some examples as well so that you all can get a good understanding of them in PLSQL. Later moving on, we will be going towards Functions in PLSQL and exception handling. After you guys have practiced enough, we will then be introducing you to triggers, package, and object-oriented concepts. Then we will be taking up some concepts like, DateTime, Transaction, Arrays Strings and Operators. We will also be giving examples and practice questions for you to learn and get hands-on on all these concepts and in the end be confident about PLSQL.

PL/SQL Introduction

In this post, we will cover the basic introduction of PL/SQL Language. We will learn about its features, how it is different from SQL, and its advantages over SQL.

Author Sanjana Yadav

0 upvotes

PL/SQL Environment Setup

In this article, we will learn how to install Oracle database in our system and set up an Environment for PL/SQL. We will also see some useful resources to learn PL/SQL.

Author Shivani Kumari

1 upvote

PL/SQL Variables

In this post, we will learn about PL/SQL variables their naming rules, declaration, initialization with examples, and a hello world program in PL/SQL.

Author Sanjana Yadav

1 upvote

PL/SQL Conditional statements

This article will discuss the various conditional statements which are used in PL/SQL. We shall also see examples on each of them.

Author Ankit Kumar

1 upvote

PL/SQL Iterative Statements

This article will discuss the various iterative statements in PL/SQL viz. basic loop, for loop, while loop, and their examples.

Author Ankit Kumar

1 upvote

PL/SQL Conditional ( Continue, exit, goto)

This article will discuss the various conditional statements in PL/SQL, like Continue, exit, goto, etc. We will also consult some FAQs related to the topic.

Author Ankit Kumar

1 upvote

PL/SQL Procedures

In this article, we will learn what PL/SQL procedures are and how and why we will use them. We will also learn about the advantages and disadvantages of using procedures.

Author Shivani Kumari

2 upvotes

In this article, we will learn about cursors and how to use them. We will also see different types of cursors used and their syntaxes.

Author Shivani Kumari

1 upvote

PL/SQL Functions

This blog introduces the concept of functions in PL/SQL, and covers how to declare, define or call the PL/SQL functions using different examples.

Author PRASHANT SINGH

1 upvote

PL/SQL - Exception Handling

We will learn about exception handling and its different types available in PL/SQL. Read the blog to learn more.

Author Purswani Dineshkumar

1 upvote

Triggers in SQL Server MEDIUM

SQL Triggers are stored programs/procedures, which are automatically executed or fired when some events occur.

1 upvote

PL/SQL Packages

This article discusses the Packages in PL/SQL with several examples in detail.

0 upvotes

PL/SQL Object Oriented

This blog will learn about objects in PL/SQL and see various ways to manipulate the objects, like accessing, updating, and deleting objects.

Author Purswani Dineshkumar

1 upvote

PL/SQL Date and Time

This blog introduces the concept of date and time in PL/SQL and covers the different types of Datetime and Interval data types with the functions used and their descriptions.

Author PRASHANT SINGH

2 upvotes

PL/SQL Transactions

A database or PL/SQL transaction is an atomic unit of work that may consist of one or more related SQL statements.

Author Pranay Chauhan

0 upvotes

In this article, we will learn in detail about PL/SQL strings and will discuss string functions and operators in-depth with suitable examples.

Author Divyansh Jain

0 upvotes

PL/SQL - Operators

This blog will learn about what operators are and see various examples of arithmetic, relational, logical, and comparison operators.

Author Purswani Dineshkumar

1 upvote