PL/SQL Package gestionInstituto for Institute Data
Classified in Visual arts
Written on in
English with a size of 3.08 KB
Package Specification: gestionInstituto
CREATE OR REPLACE PACKAGE gestionInstituto
AS
Cursors
CURSOR curAlumnos IS SELECT * FROM alumnos;
CURSOR curNotas IS SELECT * FROM notas;
CURSOR curAsignaturas IS SELECT * FROM asignaturas;Functions and Procedures
FUNCTION media (codigo notas.cod%TYPE) RETURN NUMBER;PROCEDURE mediaMayor (codigo notas.cod%TYPE);PROCEDURE verTablas;PROCEDURE insertarAlumno (
NIE alumnos.dni%TYPE,
nombre alumnos.apenom%TYPE,
direccion alumnos.direc%TYPE,
telefono alumnos.telef%TYPE
);END gestionInstituto;Package Body: gestionInstituto
CREATE OR REPLACE PACKAGE BODY gestionInstituto
AS
Function: media
FUNCTION media (codigo notas.cod%TYPE) RETURN NUMBER
IS
mediaNotas NUMBER;
BEGIN
SELECT AVG(nota)
INTO mediaNotas... Continue reading "PL/SQL Package gestionInstituto for Institute Data" »