You have generated the demo data for the SQL Tutorial.
Log on to the demo database instance DEMODB as user MONA.
Create database functions. Proceed as described in the SQL Tutorial, Database Functions.
You can use the system table FUNCTIONS to determine the following database information, among other things:
? All database functions of the HOTEL schema that were created in the last 10 days
SELECT schemaname, functionname
WHERE schemaname = 'HOTEL' AND createdate >= SUBDATE(DATE,10)
? Parameters of the database function AVGPRICE
SELECT schemaname, functionname, parameter
WHERE functionname = 'AVGPRICE'
Parameters of a database function: see DBPROCPARAMS