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
|