Function plsql

CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS
    cnumber NUMBER;
BEGIN
    cnumber := 2;
    RETURN (cnumber * param1);
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

Similar codes

0 vote202 views1 answer
See the structure of a table mysql
SQL
0 vote184 views1 answer
Opensuse stop MySQL
SQL
0 vote194 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
15 votes218 views6 answers
Laravel db transaction
SQL
1 vote210 views2 answers
Rebuild index sql server
SQL
0 vote208 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote208 views1 answer
How to find database collation in postgres
SQL
-1 vote210 views1 answer
Io
SQL
0 vote205 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
11 votes204 views3 answers
Sql_mode=only_full_group_by
SQL