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 vote231 views1 answer
Mysql show schema
SQL
0 vote201 views1 answer
Oracle date winter time
SQL
0 vote254 views1 answer
Fetching data from mysqldb
SQL
6 votes252 views2 answers
Install psql mac
SQL
0 vote188 views1 answer
Compare subqueries oracle
SQL
4 votes204 views4 answers
Pl sql output
SQL
12 votes237 views6 answers
How to install sqlite3 in python
SQL
0 vote199 views1 answer
T sql check active deadlock
SQL
7 votes198 views5 answers
Oracle alter table
SQL
0 vote142 views1 answer
Mssql view column data type
SQL