LATEST APPSGONEFREE Follow us on twitter
GearAdvice AppAdvice/TV NowGaming WatchAware

SQL Functions Reference

SQL Functions Reference

by Seer Computing Ltd

What is it about?

SQL Functions Reference

App Details

Version
1.0
Rating
NA
Size
10Mb
Genre
Business Reference
Last updated
May 4, 2016
Release date
May 4, 2016
More info

App Screenshots

App Store Description

SQL Functions Reference

A list of all functions available in Oracle SQL including working examples

How many times have you sat at your desk trying to remember that SQL function you need in your code ? even worse you know the name of the function but can’t get it to work.

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.

Disclaimer:
AppAdvice does not own this application and only provides images and links contained in the iTunes Search API, to help our users find the best apps to download. If you are the developer of this app and would like your information removed, please send a request to takedown@appadvice.com and your information will be removed.