Yahoo Poland Wyszukiwanie w Internecie

Search results

1. www.oracletutorial.com › plsql-tutorial › plsql-procedurePL/SQL Procedure - Oracle Tutorial

   www.oracletutorial.com › plsql-tutorial › plsql-procedure

   • Zapisane w pamięci cache

   A PL/SQL procedure is a reusable unit that encapsulates the specific business logic of the application. Technically speaking, a PL/SQL procedure is a named block stored as a schema object in the Oracle Database. The following illustrates the basic syntax of creating a procedure in PL/SQL:

   • Oracle Implicit Statement Results

     Summary: in this tutorial, you will learn how to return one...

   • Cursors

     PL/SQL has two types of cursors: implicit cursors and...

   • Exceptions

     PL/SQL treats all errors that occur in an anonymous block,...

   • NULL Statement

     PL/SQL requires at least one executable statement in the...

2. www.tutorialspoint.com › plsql › plsql_proceduresPL/SQL - Procedures - Online Tutorials Library

   www.tutorialspoint.com › plsql › plsql_procedures

   • Zapisane w pamięci cache

   Learn how to create, execute and delete procedures in PL/SQL, a procedural extension of SQL. Procedures are subprograms that do not return a value directly and can have parameters with different modes.

3. www.geeksforgeeks.org › sql-proceduresProcedures in PL/SQL - GeeksforGeeks

   www.geeksforgeeks.org › sql-procedures

   • Zapisane w pamięci cache

   8 sie 2024 · A PL/SQL procedure consists of two main parts: the procedure header, which includes the procedure name and optional parameters, and the procedure body, which contains the executable statements that define the procedure’s logic.

4. www.plsqltutorial.com › plsql-procedurePL/SQL Procedure - PL/SQL Tutorial

   www.plsqltutorial.com › plsql-procedure

   • Zapisane w pamięci cache

   Learn how to create and call a PL/SQL procedure that updates the salary of employees in the HR database. A PL/SQL procedure is a named block that does a specific task and can have parameters, exceptions and a return statement.

5. www.geeksforgeeks.org › pl-sql-tutorialPL/SQL Tutorial - GeeksforGeeks

   www.geeksforgeeks.org › pl-sql-tutorial

   • Zapisane w pamięci cache

   20 cze 2024 · PL/SQL with our comprehensive tutorial! Master procedures, functions, triggers, and more to write robust database applications. This beginner-friendly guide covers everything from the basics to advanced topics.

6. www.guru99.com › pl › subprograms-procedures-functions-pl-sqlOracle Procedury i funkcje składowane PL/SQL z przykładami -...

   www.guru99.com › pl › subprograms-procedures-functions-pl-sql

   • Zapisane w pamięci cache

   28 cze 2024 · W tym samouczku zobaczysz szczegółowy opis tworzenia i wykonywania nazwanych bloków (procedury i funkcje). Procedury i funkcje to podprogramy, które można tworzyć i zapisywać w bazie danych jako obiekty bazy danych. Można je wywoływać lub odnosić się do nich również w innych blokach.

7. www.geeksforgeeks.org › how-to-write-a-simple-select-stored-procedure-in-plsqlHow to Write a Simple SELECT Stored Procedure in PL/SQL?

   www.geeksforgeeks.org › how-to-write-a-simple-select-stored-procedure-in-plsql

   • Zapisane w pamięci cache

   23 paź 2024 · A stored procedure in PL/SQL is a subprogram that performs a specific task and is stored within the database for repeated use. It encapsulates SQL statements and procedural logic, enabling developers to execute complex operations with a single call.