Instruction
Congratulations! You've just completed function management. It's time to quickly review what we've learned in this part:
- The
CREATE FUNCTIONstatement is used to create a new function. - The
CREATE OR REPLACE FUNCTIONcommand allows us to change the definition of a function. If the specified function doesn't exist, the command creates it. If the function exists, it is replaced. - To rename a function, you can use the
ALTER FUNCTION ... RENAME TOcommand. - The
DROPcommand with theIF EXISTSoption can be used to remove a function that is no longer needed.
We hope you enjoyed this part and learned something new about function management. See you in the last part!
Exercise
Click to finish this part.




