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

6 votes199 views2 answers
Mysql get yesterday
SQL
0 vote202 views1 answer
Python mysql show databases
SQL
-1 vote208 views1 answer
Export mysql table to file
SQL
1 vote221 views1 answer
Sql drop schema
SQL
1 vote210 views1 answer
Select tables with name like mysql
SQL
6 votes261 views2 answers
How to get yesterday date in mysql
SQL
33 votes186 views2 answers
Postgres how to add field created at
SQL
0 vote191 views1 answer
Mysql cdn link
SQL
10 votes216 views1 answer
Oracle dependencies table
SQL
19 votes222 views3 answers
Grant mysql
SQL