Skip to content

Tag Archives: SQL-PL/SQL

Prerequisite – PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part,… Read More
Prerequisite – PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part,… Read More
You have given a number n then you have to print number a right-angled pyramid of * Examples:   Input : 3 Output : * ** ***… Read More
There come situations in real life when we need to make some decisions and based on these decisions, we decide what should we do next.… Read More
Prerequisite – PL/SQL introductionIn PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements.  In declare part, we… Read More
Given a number, your task to print the factorial of that number using pl/sql. Examples: Input : 5 Output : 120 Explanation: 5! = 5… Read More
An exception is an error which disrupts the normal flow of program instructions. PL/SQL provides us the exception block which raises the exception thus helping… Read More
PL/SQL is a block structured language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed… Read More
A function can be used as a part of SQL expression i.e. we can use them with select/update/merge commands. One most important characteristic of a… Read More
Pseudocolumn: A pseudo-column behaves like a table column but is not actually stored in the table. You can select from pseudo-columns, but you cannot insert,… Read More
Let’s see how we can print the pattern of various type using SQL. Syntax : Declare @variable_name DATATYPE -- first declare all the -- variables… Read More
PL/SQL is a block-structured language that enables developers to combine the power of SQL with procedural statements. A stored procedure in PL/SQL is nothing but… Read More