Procedure syntax

CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

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;

Similar codes

0 vote136 views2 answers
How to relationship query two different tables in MySQL
SQL
2 votes140 views1 answer
Get hour from date sql
SQL
0 vote145 views1 answer
Sp in sql server
SQL
1 vote145 views2 answers
Mysql remove first and last character from string
SQL
3 votes94 views1 answer
If 0 return null else return query mysql
SQL
1 vote193 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote145 views1 answer
Nosql vs sql
SQL
1 vote138 views1 answer
Convert rows to string sql server
SQL
0 vote149 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote152 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL