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 vote267 views1 answer
Mysql f# examples
SQL
0 vote259 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
12 votes289 views6 answers
How to install sqlite3 in python
SQL
0 vote293 views1 answer
Sql: extract day text from datetime value
SQL
0 vote280 views1 answer
Xamarin sql lite create table if not exist
SQL
9 votes252 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote259 views1 answer
Incorrect string value: mysql
SQL
0 vote278 views1 answer
Print hello world in plsql
SQL
0 vote264 views1 answer
Drop a field in psql django
SQL
5 votes301 views6 answers
In operator sql
SQL