Home arrow Oracle arrow Page 2 - Oracle Stored Procedures

Before you start - Oracle

So what's this business with Oracle allowing programmers to put programs in databases? That's right. They're called Oracle stored procedures, and they're quite useful. Mooh the Cow walks you through writing, creating, debugging, and deleting a procedure.

  1. Oracle Stored Procedures
  2. Before you start
  3. Write a procedure
  4. Create a procedure
  5. Run a procedure
  6. Change a procedure
  7. Debug a procedure
  8. Drop a procedure
  9. What you have learned
  10. Further reading
By: Mooh The Cow
Rating: starstarstarstarstar / 879
January 03, 2005

print this article



To make the most of this article, try out the code examples provided. You will need some basic software and skills.

Your software checklist:

  • A text editor. The code examples were written with Microsoft Notepad version 5.1, supplied with the operating system called Microsoft Windows XP Professional.

  • A tool to submit Oracle SQL and PL/SQL statements to an Oracle database. The code examples were tested in Oracle's SQL*Plus tool, version for Windows.

  • An Oracle database you can connect to with a user name and password. Your user name should be set up with the permission to write procedures: the CREATE PROCEDURE system privilege. The code examples were tested on an Oracle9i database, version 9.2.0.

Your skills checklist:

  • Basic knowledge of SQL, the language used to manipulate (insert, update and delete) data in a relational database.

  • Basic experience using Oracle's SQL*Plus tool.

  • Basic experience using Oracle's PL/SQL programming language.

Now, to get you started, let's learn how to write a procedure.

>>> More Oracle Articles          >>> More By Mooh the Cow

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: