Oracle Business Intelligence Discoverer 11g Handbook

APPENDIX

B

SQL Functions

This appendix contains an alphabetic listing of all the SQL functions available within Discoverer. Each function is listed with its correct syntax, an explanation of its purpose or use, and the Discoverer folder in which you will find the function. For most functions, we will give you examples. We also explain in depth how to use the wildcard characters within Discoverer. If you are looking for more information regarding analytic functions, please see Chapter 21.

We will give you a complete listing of all the format masks that can be applied to functions. Finally, we will give you a listing of the standard American Standard ...