What Is a Stored Procedures?
This section describes what is a stored procedure - is an executable program that is stored in the database server.
What Is a Stored Procedure?
A stored procedure is an executable program that is stored in the database server
waiting to be called for execution. A stored procedure should be written in a programming
language that is supported by the database server. Some database servers offer special
languages that are extended from the standard SQL. For example:
- PL/SQL - Stored procedure language for Oracle database server.
- Transact SQL - Stored procedure language for MS SQL server.
Store procedure languages usually offer you statements to:
- Receive and return data from the calling environment.
- Declare and use local variables.
- Execute regular SQL statements on the server.
- Loop through a set of statements multiple times.
- Conditionally control the execution flow.
Last update: 2015.
Table of Contents
About This Book
Introduction of SQL
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
PHP Programs and MySQL Servers
Java Programs and MySQL Servers
Datatypes and Data Literals
Operations and Expressions
Character Strings and Bit Strings
Commonly Used Functions
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Transaction Management and Isolation Levels
Locks Used in MySQL
►Defining and Calling Stored Procedures
►What Is a Stored Procedures?
CREATE PROCEDURE - Statement to Create Stored Procedures
Stored Procedure Parameters
Variables, Loops and Cursors Used in Stored Procedures
PDF Printing Version