GitHub

PL_SQL Procedure and Function

Procedure and Funtion are subprograms that consists of a group of PL/SQL statements. This subprogram unit is stored as a database object. Once creating produre or function in a database, can call and ...
GitHub

PL_SQL stored procedure and function.txt

create table stud_marks(name varchar(20),total_marks int(5)); create table Result(roll_no int(3) primary key,name varchar(20),class varchar(20)); insert into stud ...
SiliconIndia

Performing a Unit Test of Your PL/SQL in Oracle SQL

The SQL Developer unit testing framework involves a set of sequential steps for each test case. The steps are as follows, including the user input for before the step is run and the framework ...
findnerd.com

Stored Procedures and Functions in MySQL - Part 2

For example lets create a stored procedure to increment salaries of employees by percentage DELIMITER $$ CREATE PROCEDURE salary_increment(increment_percent decimal(5,2)) BEGIN UPDATE employee_master ...
Ars Technica

pl/sql: split?

Does anyone know how I might split a string into an array in pl/sql? The kind folks at Oracle chose not to include that functionality in their language, and now I'm up a creek.<BR><BR>I need to split ...