Given below is how to add a MySQL/Oracle function call to a data service.
|Table of Contents|
Calling a MySQL function
Assume you have the following MySQL function, which takes a string parameter and returns the same as output. Create a database before executing the query.
You can also call this function in the Query Details page of the management console as follows:
Calling an Oracle function
Assume you have the following Oracle stored function, which returns the total number of entries in a table: