PL/SQL Programming Practice for Oracle Databases
Printing Student Information with PL/SQL Block
Enable server output to view printed output before executing the block. The following code defines a custom record type for student data, a local printing procedure that acccepts the record as a parameter, assigns sample student data, and prints the result to the console:
SET SERVEROUTPUT ON;
DECLA ...
Posted on Wed, 16 Sep 2026 16:23:33 +0000 by mtucker6784
Working with Advanced Data Types and Stored Procedures in JDBC
Advanced Data Types Overview
Advanced data types allow relational databases to handle flexible column values. Columns can store BLOB (binary large objects) containing substantial amounts of raw binary data, or CLOB (character large objects) storing extensive character-based data.
The current ANSI/ISO SQL standard, known as SQL:2003, specifies t ...
Posted on Sun, 06 Sep 2026 16:06:00 +0000 by macattack
Writing Efficient MySQL Stored Procedures: A Practical Reference
Creating a Stored Procedure
CREATE PROCEDURE <procedure_name> (parameter_list datatype)
BEGIN
<body -- SQL statements>
END;
Example:
DROP PROCEDURE IF EXISTS FetchTopEmployees;
CREATE PROCEDURE FetchTopEmployees()
BEGIN
SELECT emp_id, first_name, last_name FROM employee ORDER BY salary DESC LIMIT 20;
END;
CALL FetchTopEmpl ...
Posted on Thu, 09 Jul 2026 17:12:55 +0000 by alfieshooter
MySQL Stored Procedures: Definition, Creation, and Parameterized Usage
Definition
A predefined, reusable set of SQL statements tailored to a specific task that executes when explicitly invoked.
Creation and Execution Syntax
2.1 Create a Stored Procedure
Lowercase syntax example:
create procedure proc_name([parameters])
begin
-- SQL statements block
end;
Uppercase syntax example:
CREATE PROCEDURE proc_name([parame ...
Posted on Mon, 22 Jun 2026 18:52:56 +0000 by skyturk
Advanced MySQL Database Objects: Views, Stored Procedures, and Triggers
Database View Fundamentals
Views provide a virtual table interface based on the result of an SQL query. They simplify complex operations and enhance data security.
Basic view operations:
-- Create or replace a view
CREATE [OR REPLACE] VIEW view_name [(column_list)]
AS SELECT_statement [ WITH [ CASCADED | LOCAL ] CHECK OPTION ];
-- Display vie ...
Posted on Thu, 07 May 2026 13:50:24 +0000 by toro04