MariaDB stored procedures

GPTKB entity

Statements (50)
Predicate Object
gptkbp:instanceOf gptkb:database
gptkbp:can_be_altered_with ALTER PROCEDURE statement
gptkbp:can_be_created_with CREATE PROCEDURE statement
gptkbp:can_be_deleted_with DROP PROCEDURE statement
gptkbp:can_be_executed_with CALL statement
gptkbp:can_be_granted_with EXECUTE privilege
gptkbp:can_be_listed_with SHOW PROCEDURE STATUS
gptkbp:can_return result sets
gptkbp:canBe gptkb:transformation
batch processing
auditing
logging
data validation
business logic
performance optimization
security enforcement
scheduling tasks
automation of tasks
triggering events
DECLARE statement
complex transactions
SELECT statement
DELETE statement
IF statement
INSERT statement
SET statement
UPDATE statement
CASE statement
CURSOR
HANDLER
ITERATE statement
LEAVE statement
LOOP statement
REPEAT statement
WHILE statement
centralized logic management
encapsulation of logic
enforcing data integrity
reducing network traffic
reusability of code
gptkbp:enables modular programming in SQL
https://www.w3.org/2000/01/rdf-schema#label MariaDB stored procedures
gptkbp:partOf gptkb:MariaDB
gptkbp:supports error handling
control flow statements
INOUT parameters
input parameters
output parameters
gptkbp:bfsParent gptkb:SQL/PSM
gptkbp:bfsLayer 8