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 vote168 views4 answers
Mysql count table rows
SQL
0 vote209 views1 answer
Psql store procedure-return multiple table values
SQL
2 votes202 views2 answers
Calculate percentage in sql
SQL
0 vote164 views1 answer
Oracle tablespace autoextend
SQL
4 votes171 views2 answers
How to delete row in sql
SQL
8 votes185 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote182 views2 answers
Sql searching via key word
SQL
0 vote176 views1 answer
Mysql join same table multiple times group by
SQL
25 votes201 views6 answers
How to change column name in mysql
SQL
0 vote208 views1 answer
Mysql relationships between tables
SQL