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 vote186 views1 answer
What is the use of index in mysql table
SQL
2 votes188 views1 answer
Compare date in sql
SQL
0 vote224 views1 answer
Turn on foreign keys check mysql
SQL
0 vote196 views1 answer
Copied text from internet not inserting in mysql
SQL
25 votes193 views6 answers
Import mysql database command line
SQL
2 votes205 views2 answers
How to rename column name in sql server using query
SQL
35 votes213 views5 answers
Sql alter column
SQL
0 vote190 views1 answer
Mariadb select limit offset
SQL
42 votes277 views6 answers
Rename table sql server
SQL
2 votes180 views1 answer
How to delete view in sql
SQL