Stored procedure sql

-- without parameters; create
CREATE [OR ALTER] PROCEDURE <pname>
AS
BEGIN
<PROCEDURE BODY/ STATEMENTS>
END

-- call procedure
EXECUTE / EXEC <pname>;
(OR)
EXECUTE / EXEC <pname> VALUE / (S)

Stored procedure sql

-- without parameters; create
CREATE [OR ALTER] PROCEDURE <pname>
AS
BEGIN
<PROCEDURE BODY/ STATEMENTS>
END

-- call procedure
EXECUTE / EXEC <pname>;
(OR)
EXECUTE / EXEC <pname> VALUE / (S)

Sql procedure

CREATE OR REPLACE PROCEDURE my_scheme.my_procedure(param1 IN VARCHAR2) IS
    cnumber NUMBER;
BEGIN
    cnumber := 10;
    INSERT INTO my_table (num_field) VALUES (param1 + cnumber);
    COMMIT;
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

What is a stored procedure

SQL Stored Procedure

-1

Similar codes

1 vote117 views2 answers
Last working day in week date function in sql
SQL
0 vote156 views2 answers
Nosqlbooster query other collection
SQL
8 votes189 views3 answers
Find table for column name in sql
SQL
50 votes249 views6 answers
Install mysql on ubuntu
SQL
4 votes150 views1 answer
SQL order random
SQL
10 votes148 views2 answers
Linux command line import mysql database
SQL
0 vote154 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
1 vote176 views1 answer
Select inside insert query
SQL
0 vote155 views1 answer
Psql initialization
SQL
0 vote244 views1 answer
Jpa generationtype sequence mysql
SQL