
	stored procedure


	Home > Oracle Definitions - Stored procedure

SearchOracle.com Definitions (Powered by WhatIs.com)

EMAIL THIS

LOOK UP TECH TERMS		Powered by:

Browse tech terms alphabetically:

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

stored procedure

Digg This!

StumbleUpon

Del.icio.us

- In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).

LAST UPDATED:

04 Apr 2005

Read more about stored procedure:

-	Search400.com has hundreds of links related to stored procedure.

Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL to count values of a status code Our SQL expert answers a question about counting values of a status code.
	Counting NULL columns Our SQL expert explains how to count null columns in a row.
	Detail rows for accounts that occur three times Our SQL expert answers a tough query using both the IN subquery and derived tables.

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

autonomous transaction (SearchOracle.com)

CFML (SearchOracle.com)

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy