PL/SQL If PL/SQL supports the programming language features like conditional statements and iterative statements. Its programming constructs are similar to how you…
Tag:
cursor
-
-
PL/SQL Loop The PL/SQL loops are used to repeat the execution of one or more statements for specified number of times. These…
-
PL/SQL Procedure The PL/SQL stored procedure or simply a procedure is a PL/SQL block which performs one or more specific tasks. It…
-
PL/SQL Trigger Trigger is invoked by Oracle engine automatically whenever a specified event occurs.Trigger is stored into database and invoked repeatedly, when…
-
PL/SQL Tutorial PL/SQL tutorial provides basic and advanced concepts of SQL. Our PL/SQL tutorial is designed for beginners and professionals. PL/SQL is…
-
PL/SQL Variables A variable is a meaningful name which facilitates a programmer to store data temporarily during the execution of code. It…
-
PL/SQL While Loop PL/SQL while loop is used when a set of statements has to be executed as long as a condition…
-
PL/SQL Case Statement The PL/SQL CASE statement facilitates you to execute a sequence of satatements based on a selector. A selector can…
-
Difference between Primary Key and Foreign Key Key in MySQL are the fundamental elements for constructing a relationship between two tables. They…
-
Difference between Primary Key and Unique key Keys in MySQL are the column or set of columns used to construct a relationship…