A program running in the database that can take complex actions based on the inputs you send it. Using a stored procedure is faster than doing the same work on a client, because the program runs right inside the database server. Stored procedures are nomally written in PL/SQL or Java.

Bhawna

• Mar 3rd, 2016

Stored Procedure is group of SQL statements which is used to do a specific task. It is a pre-complied object which is complied for the first time and stored in server database so that it can be used again and again.

guruprasad

• Oct 3rd, 2012

Stored Procedure is a re-usable program which is created once and reused n times .
It stores the procedure at database level
It provides security, better performance.

Answer Question  Select Best Answer