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

2 votes116 views2 answers
Change mysql password from command line
SQL
1 vote102 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote98 views1 answer
Min:sec datediff mssql
SQL
0 vote112 views1 answer
Sql decode
SQL
16 votes114 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote128 views1 answer
Find how many tables in database sql query
SQL
0 vote106 views1 answer
Sql server query database space available
SQL
0 vote112 views1 answer
Mysql add root password
SQL
0 vote107 views1 answer
How to add session data into mysql database from button
SQL
0 vote98 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL