Subscribe:

Main Menu

Jumat, Mei 30, 2008

Contoh Store Procedure di Pl/Pgsql


CREATE OR REPLACE FUNCTION
namaStoreProcedure(Parameter)
RETURNS SETOF
returnValue AS
$BODY$
DECLARE
Letak Deklarasi variabel
BEGIN
Letak Programnya disini
RETURN NEXT
returnValue;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

0 komentar: