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 vote141 views1 answer
Dump only data
SQL
1 vote145 views1 answer
Mysql find most common value
SQL
15 votes143 views4 answers
Create table if not exists sql
SQL
0 vote133 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote182 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
2 votes182 views3 answers
Mysql kill
SQL
1 vote145 views1 answer
Age postgres
SQL
1 vote128 views1 answer
Sql server 2012 query history
SQL
0 vote131 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote141 views1 answer
Use between operator in mysql
SQL