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

1 vote153 views1 answer
Search for replace in mysql
SQL
8 votes144 views2 answers
Update sql server from another table
SQL
0 vote144 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote148 views1 answer
Mysql grant grant option
SQL
0 vote148 views1 answer
Sql query contains multiple ids
SQL
0 vote151 views1 answer
Recover deleted data from mysql database
SQL
0 vote158 views1 answer
Sqlserver now
SQL
6 votes237 views2 answers
Database url postgres
SQL
0 vote163 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote156 views1 answer
Sql on-premises
SQL