Simple functions such as FLOOR or ROUND tend to stick in your mind, but what about DEREF or FIRST_VALUE or RANK, these functions are in some circumstances vital to your work but what if you can’t remember them or need an example of its syntax ?
Our Oracle SQL Reference app lists all available functions, gives a concise explanation of each and at least one example of its usage, each accompanied with the output of the select statement.
The functions are listed alphabetically, but a pull down drawer splits the functions into their specific usage, therefore they are sub-grouped into the following key areas …
Number
String
Date
Analysis
Aggregate
Regex
Timestamp
Misc
In addition we have added sections which our own Developers have identified as useful aids to the memory, therefore we break down the lists of Number and Date formats, list all the types of Where clauses, using aliases etc … all very useful when writing SQL and PLSQL
We offer two versions of this app, one free with adverts the other a paid version without adverts, both are the same, both work on Phones, and all sizes of Tablets, we hope you will find them useful, we do.
You are allowed to use this product only within the laws of your country/region. SharewareOnSale and its staff are not responsible for any illegal activity. We did not develop this product; if you have an issue with this product, contact the developer. This product is offered "as is" without express or implied or any other type of warranty. The description of this product on this page is not a recommendation, endorsement, or review; it is a marketing description, written by the developer. The quality and performance of this product is without guarantee. Download or use at your own risk. If you don't feel comfortable with this product, then don't download it.
Reviews for SQL Functions Reference
Click Here to Read Reviews for SQL Functions Reference >> Click Here to Submit Reviews for SQL Functions Reference >>