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 vote176 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote162 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote147 views1 answer
Mysql offset from bottom
SQL
0 vote207 views1 answer
Synapse sql table set pk
SQL
6 votes184 views5 answers
Sql add months to date
SQL
0 vote216 views1 answer
Take sql dump in to file
SQL
13 votes202 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote198 views1 answer
T sql dynamic top n query
SQL
11 votes234 views2 answers
Docker create postgres db
SQL
0 vote221 views1 answer
Mysql date equals to current_date plus days
SQL