Oracle - Create a Stored Procedure in Oracle

Create a Stored Procedure in Oracle

Q

How To Create a Stored Procedure in Oracle?

✍: FYIcenter.com

A

A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example script below creates a stored procedure:

SQL> CREATE PROCEDURE Greeting AS
  2  BEGIN
  3    DBMS_OUTPUT.PUT_LINE('Welcome to FYICenter!');
  4  END;
  5  /
Procedure created.

⇒Creating Oracle PL/SQL Procedures and Functions

⇒⇒Oracle Database Tutorials

2016-10-17, 374👍, 0💬

Popular Posts:

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...

CONVERT() - Converti...

How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...

Import One Table bac...

How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

AND, OR, XOR, and NO...

What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...