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

0 vote244 views1 answer
Selecting Multiple Columns in SQL
SQL
2 votes244 views2 answers
Sql query to copy data from one column to another
SQL
36 votes205 views6 answers
Rename table sql
SQL
13 votes196 views5 answers
Alter table query sql server change column
SQL
0 vote177 views1 answer
Postgresql certain first 4 characters in string
SQL
2 votes248 views1 answer
Match in sql server
SQL
0 vote206 views1 answer
How to create a new shema using query languaage
SQL
1 vote195 views1 answer
MySQL AND Operator
SQL
15 votes193 views1 answer
Mysql int range
SQL
2 votes192 views1 answer
Alter table add column and foreign key mysql
SQL