Showing posts with label Basic PLSQL. Show all posts
Showing posts with label Basic PLSQL. Show all posts
Friday, May 10, 2019

Loops in Stored Procedures

›
Whenever we execute a procedure each query or statement is executing once.  Loop is a programming concept which is used to execute a group...
Monday, May 6, 2019

Correlated Subquery

›
Subquery which is depending on outer query output is called correlated subquery.  First outer query is executed, based on the output, subq...
Friday, May 3, 2019

Subquery

›
What is Subquery? Explain the Properties of a Subquery? A query which is nested within another query is called subquery. If you want to f...

Cursors

›
A cursor is a pointer to this temporary work area (context area) created in the system memory, when a SQL statement is executed. Temporary ...
Thursday, April 25, 2019

Functions in PLSQL

›
A function in PL/SQL is a named block of code that: * Accepts input parameters * Performs a task or computation * Returns a single value usi...
Tuesday, April 16, 2019

Triggers in PLSQL

›
Triggers in PL/SQL:- ----------------- Trigger is one of the Database Objects which is saved in database. Triggers are automatically or i...

Procedures in PL/SQL

›
If a program or query that is stored as a procedure permanently in the database is called "Stored Procedure". It is saved in data...

Introduction to PLSQL

›
PLSQL is the combination of SQL statements. To increase the capabilities of SQL PLSQL is introduced.  Full form of PLSQL is 'Procedural...