Definition

stored procedure

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).

Related glossary terms: The Open Group, dynamic SQL (Dynamic Structured Query Language), autonomous transaction, CFML (ColdFusion Markup Language), Java Database Connectivity (JDBC), Query by Example (QBE), Open Database Connectivity (ODBC), foreign key (foreign keyword)

This was last updated in September 2005

Posted by: Margaret Rouse

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

More News and Tutorials

Doing SQL arithmetic with SELECT instead of arithmetic operations

Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Using SQL SELECT and SQL UNION ALL statements to sort numbers

Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures.

Articles
Resources from around the Web
- Selecting ODBC functions for optimized SQL statements
- SQL Server data encryption fast guide

Do you have something to add to this definition? Let us know.

Send your comments to techterms@whatis.com

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Research More Tech Terms

Search thousands of tech definitions
Browse tech definitions
Browse 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
- #

Powered by WhatIs.com

File Extensions and File Formats

File Extension and File Formats List:

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
#

Powered by WhatIs.com

More from Related TechTarget Sites

Data Management
Business Analytics
SAP
SQL Server
Java
Data Center
Content Management
Financial Applications

Data Management
- New BI stack tackles data load at Boston Children's Hospital
  
  Boston Children's Hospital upgraded its business intelligence architecture to boost enterprise reporting, a move that also required retraining users.
- Expanded Hadoop use cases will drive need for new enterprise features
  
  With user interest rising, Hadoop vendors are trying to pave a path to higher adoption with add-ons that target issues holding the technology back.
- Jim Goodnight on SAS in-memory analytics and the data scientist
  
  A podcast Q&A with SAS execs Jim Goodnight and Jim Davis looks at big data enablers, including in-memory analytics, and the role of data scientists.
Business Analytics
- Match in-memory processing speed to big data analytics business need
  
  Michael Minelli, co-author of a book on big data analytics, says in-memory analytics tools must be tied to business processes to pay off for users.
- MIT panelists: Big data calls for data-driven decision making skills
  
  C-level execs need to develop better decision making skills to capitalize on big data technology, said speakers at the 2013 MIT Sloan CIO Symposium.
- In-memory analytics tools pack potential big data punch
  
  The faster analytics performance spurred by in-memory technology can help companies capitalize on big data, but there are barriers to be aware of.
SAP
- SAP social collaboration strategy grinds forward with SAP JAM
  
  SAP Jam is an improvement over SAP StreamWork in terms of integration with business processes, but questions still remain over its viability, William Newman writes.
- Analyst Jon Reed on SAP SapphireNow 2013, SAP Fiori
  
  Analyst Jon Reed gives his take on SAP Fiori, a collection of apps intended to cover a wide range of business processes as simply and efficiently as possible.
- Ariba Network announces QuickBooks integration
  
  At its annual conference, Ariba announced a new tool by partner Dell Boomi that lets small businesses integrate their QuickBooks accounting with the Ariba Network.
SQL Server
- Database index design and optimization: Some guidelines
  
  What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
- Adam Machanic talks SQL Saturday
  
  We caught up with Adam Machanic, group leader of the New England SQL Server user group, at SQL Saturday Boston. Find out what he shared with us.
- SQL Server meets database application security
  
  Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.
Java
- Inside advice on the use of Platform as a Service in the enterprise
  
  CloudBees founder and CEO Sacha Labourey answers tough questions and hands out practical advice about PaaS and how it works in the enterprise.
- How skilled portlet developers make the portal strategy work
  
  Portals are providing more value than ever, and having skilled portlet developers on staff brings the technology to new levels.
- Five portlet development tips software engineers can't ignore
  
  Here are five quick portlet development tips that software engineers will find helpful as they develop applications for the portal.
Data Center
- Data center modernization starts with cloud, SDN and virtualization
  
  Some of the technologies driving data center modernization include cloud computing, flash storage, virtualization and software-defined networking.
- Data center technologies evolve to meet tomorrow's computing demands
  
  VMware's upcoming public cloud and AMD's 64-bit ARM servers are technologies for the data center that exemplify the changes in the IT industry.
- New data center cooling strategies to improve efficiency, lower costs
  
  Stagnant strategies for data center cooling will keep energy bills climbing ever higher, but a more modern approach can bring them back down to earth.
Content Management
- IT leaders can learn from users' concerns about Tumblr-Yahoo deal
  
  Users of the Tumblr blogging site worry about what will happen to their content after Yahoo's acquisition, and IT execs can learn from the situation.
- Get 'em ready: Tips for planning a SharePoint 2013 training program
  
  SharePoint is a complex application. But training business users for an upgrade to SharePoint 2013 doesn't have to be a daunting task for IT teams.
- The organization of the future: Not just hybrid IT, but hybrid people
  
  The adoption of hybrid IT approaches creates a need for executives who can both formulate business objectives and assess IT requirements.
Financial Applications
- PeopleSoft HCM 9.2 strengthens healthcare user's confidence
  
  The latest version of PeopleSoft's HCM product is alleviating one healthcare company's concerns about the future of the healthcare product line.
- HR software customers speak out: Six stories
  
  We've rounded up our most compelling human resources software case studies for a diverse sampling of peer-to-peer advice.
- With HANA, SAP is disrupting business models -- including its own
  
  At Sapphire Now 2013, in-memory analytics and mobile app demos showed how companies can turn big data into profitable service lines.

All Rights Reserved,Copyright 2003 - 2013, TechTarget