Welcome

PL SQL Tutorial


PL SQL Stored Procedures

    PL/SQL Stored Procedures are sub-routines, executes sequence of SQL Statements(one or more).It is a schema Object,precompiled code stored in the database. It has Name, takes parameters, Paramaters can be SQL or PL/SQL Data Types. These stored procedures are going to be called in Higher Programming Language,like C,C++,Java,Python etc., Parameters should be of SQL Types, Where as these are going to be used within Oracle Database Applications,it takes PL/SQL Data Types also.

Pl/SQL Stored Procedures Syntax
CREATE [OR REPLACE] PROCEDURE name[ (parameter[,parameter]) ]  
	{ IS | AS }
	declaration_section
BEGIN
	executable_section
[EXCEPTION
	exception_section]
END [name];    	
      	

ADS