Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
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.
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.
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.
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.
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.
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.
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.
PL/SQL Cursors
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.
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.
PL/SQL - Exception Handling
We will learn about exception handling and its different types available in PL/SQL. Read the blog to learn more.
Triggers in SQL Server MEDIUM
SQL Triggers are stored programs/procedures, which are automatically executed or fired when some events occur.
PL/SQL Packages
This article discusses the Packages in PL/SQL with several examples in detail.
Author Alisha
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.
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.
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.
PL/SQL Strings
In this article, we will learn in detail about PL/SQL strings and will discuss string functions and operators in-depth with suitable examples.
PL/SQL - Operators
This blog will learn about what operators are and see various examples of arithmetic, relational, logical, and comparison operators.