Search results with tag "Stored procedures"
Views, Stored Procedures, Functions, and Triggers
eecs.csuohio.eduStored Procedures in MySQL A stored procedure contains a sequence of SQL commands stored in the database catalog so that it can be invoked later by a program Stored procedures are declared using the following syntax: Create Procedure <proc-name> (param_spec 1, param_spec 2, …, param_spec n) begin-- execution code end;
Client Server Architecture - DoACT, AKT
mazsola.iit.uni-miskolc.huImplementation of Business Logic at the Server Active elements in the Databases - triggers - stored procedures Trigger: stored DBMS procedures that are executed when there is change in
GUJARAT TECHNOLOGICAL UNIVERSITY
www.gtu.ac.in9 PL/SQL Concepts : Cursors, Stored Procedures, Stored Function, Database Triggers 03 05 Reference Books: 1. An introduction to Database Systems, C J Date, Addition-Wesley. 2. Database System Concepts, Abraham Silberschatz, Henry F. Korth & S. Sudarshan, McGraw Hill. 3. Understanding SQL by Martin Gruber, BPB 4. SQL- PL/SQL by Ivan bayross