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 vote317 views1 answer
See the structure of a table mysql
SQL
0 vote295 views1 answer
Drop constraint in ms sql
SQL
0 vote297 views1 answer
Java mysql swing example
SQL
3 votes277 views1 answer
Make a field auto_increment mysql
SQL
0 vote290 views1 answer
Mssql view column data type
SQL
38 votes337 views6 answers
Alter table mysql
SQL
1 vote292 views1 answer
Sql server datetime vs datetime2
SQL
2 votes279 views1 answer
Delete all value query
SQL
0 vote295 views4 answers
Mysql desactivar trigger
SQL
4 votes279 views1 answer
Adding data to table in sql python
SQL