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 votes329 views2 answers
Sql sequence
SQL
0 vote307 views2 answers
Oracle select
SQL
0 vote294 views1 answer
Rollback to name in sql
SQL
1 vote312 views1 answer
Table infromation in sql server
SQL
0 vote299 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
1 vote254 views1 answer
Strict in postgres SQL
SQL
3 votes346 views1 answer
What is having
SQL
0 vote317 views1 answer
Check if a column is a primary key in sql server
SQL
2 votes295 views1 answer
Import large .sql files into lampp
SQL
0 vote285 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL