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 vote196 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
2 votes199 views1 answer
Grant revoke privileges to mysql username
SQL
3 votes179 views1 answer
Oracle user quota unlimited
SQL
0 vote181 views1 answer
Postgres read table structure
SQL
0 vote179 views1 answer
Mysql convert charset
SQL
0 vote243 views1 answer
Scheduled mysql database backup in linux
SQL
5 votes178 views4 answers
Describe table postgres
SQL
0 vote183 views1 answer
Show create table in postgresql
SQL
1 vote197 views1 answer
How to truncate a table in databse
SQL
0 vote249 views1 answer
Best sql collation
SQL