Oracle Custom Functions function

Example code:

[SQL]View PlainCopy

2. CREATE OR REPLACE FUNCTION "My_database"." F_get_user_count_by_depart "
4. (
6. Depart_id_val in long
8. )
10. return VARCHAR2
12. Is
14. User_state varchar (16);
16. User_count number;
18. Begin
20. Select Count (*) into user_count from tb_user_info where depart_id=depart_id_val;
24. If User_count > 0 Then
26. user_state:=' users ' under the Department;
28. Else
30. user_state:=' No user in the department ';
32. End If;
36. return (user_state);
38. End

Explain:

[SQL]View PlainCopy

2. CREATE OR REPLACE FUNCTION "database name"." Function name "
4. (
6. Parameter one [in, out] type,
8. Parameter two [in, out] type,
10. ...
12. )
14. return value type
16. Is
18. variable one type;
20. Variable two types;
22. ... ;
24. Begin
26. /* The process of assigning a value to a variable */
30. return (variable one or variable two or ...);
32. End

1. There are two types of arguments, in or out, and you can create functions without parameters;
2. Multiple parameters are separated by ",", with ";" between multiple variables; Separated

Oracle Custom Functions function