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

11 votes128 views2 answers
Sql rank
SQL
0 vote123 views2 answers
Mysql select date from datetime
SQL
14 votes126 views3 answers
Oracle sql limit results
SQL
0 vote112 views3 answers
Postgres trim string
SQL
0 vote115 views1 answer
On update current_timestamp jpa
SQL
32 votes134 views6 answers
Rename column mysql
SQL
13 votes116 views2 answers
Get date from now() mysql
SQL
0 vote118 views1 answer
Start and stop mysql
SQL
19 votes200 views5 answers
Mysql between date range
SQL
1 vote141 views1 answer
Mysql select all and rename one
SQL