The QlikView script itself doesn't care about what commands and functions you pass to your back end oracle DB. Everything that is enclosed in the SQL .......; part is sent to the driver as is. Then it's up to the DB connector to make sense of it and return a dataset.
So, basically Yes, you should be able to use any functions supported by your driver and DB, but it's not really QlikView doing anything special except passing the request along to the driver and returning the data (or potential error message from the driver if your syntax is incorrect for example).
