About 273,000 results
Open links in new tab
  1. PL/SQL Procedures - Oracle Tutorial

    This tutorial shows you step by step how to create, compile, and execute a PL/SQL procedure from Oracle SQL Developer tool.

  2. Procedures in PL/SQL - GeeksforGeeks

    Aug 5, 2025 · They consist of two main components such as the procedure header which defines the procedure name & optional parameters and the procedure body which contains the …

  3. PL/SQL - Procedures - Online Tutorials Library

    Procedures − These subprograms do not return a value directly; mainly used to perform an action. This chapter is going to cover important aspects of a PL/SQL procedure.

  4. PL/SQL Procedure

    A PL/SQL procedure is a named block that performs one or more actions. PL/SQL procedure allows you to wrap complex business logic and reuse it in both database layer and application …

  5. Oracle PL/SQL Stored Procedure & Functions with Examples

    Jun 28, 2024 · A Procedure in PL/SQL is a subprogram unit that consists of a group of PL/SQL statements that can be called by name. Each procedure in PL/SQL has its own unique name …

  6. CREATE PROCEDURE - Oracle Help Center

    Use the CREATE PROCEDURE statement to create a standalone stored procedure or a call specification. A procedure is a group of PL/SQL statements that you can call by name.

  7. Subprograms: PL SQL Procedures And Functions With Examples

    Apr 1, 2025 · A procedure or function is a collection of PL/SQL and SQL statements that can execute a specific task. A procedure can do an action and not compulsorily return a value.

  8. Procedures - PL/SQL

    The syntax for a procedures is as follows: [Declaration Statements] [Executable Statements] [Exception handlers] Opensource project with codes on github.

  9. Oracle / PLSQL: Procedures - TechOnTheNet

    This Oracle tutorial explains how to create and drop procedures in Oracle / PLSQL with syntax and examples. In Oracle, you can create your own procedures. The syntax for a procedure is:

  10. How to Write a Simple SELECT Stored Procedure in PL/SQL?

    Jul 23, 2025 · In PL/SQL, stored procedures are powerful tools for encapsulating logic and executing complex queries. This article will guide you through the process of creating a simple …