Table Of Contents
Latest update [menu]
Changes to toolbar, aligning color scheme to IPhone version
Minor spelling mistakes corrected
Updated Copyright
Updated Search facility to include description field as well as function name
Added higher resolution images
Description [menu]
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.
How to install SQL Functions Reference (free) APK for Android [menu]
Download SQL Functions Reference (free) APK file (seer.computing.sqlfunctions_free_4_2485062.apk) from SameAPK.com, then follow these steps:
Update Phone Settings
- Go to your phone Settings page
- Tap Security or Applications (varies with device)
- Check the Unknown Sources box
- Confirm with OK
Go to Downloads
- Open Downloads on your device by going to My Files or Files
- Tap the APK file you downloaded (seer.computing.sqlfunctions_free_4_2485062.apk)
- Tap Install when prompted, the APK file you downloaded will be installed on your device.
How to install SQL Functions Reference (free) APK on Windows 7/8/10 or MAC PC? [menu]
Download SQL Functions Reference (free) APK file(seer.computing.sqlfunctions_free_4_2485062.apk) from SameAPK.com to your PC (ex: /Users/xxx/Downloads/(seer.computing.sqlfunctions_free_4_2485062.apk)), then follow these steps:
Using Emulator:
- Download And Install one Emulator Softwares (Ex: Bluestacks, GenyMotion, NoxPlayer)
- Simple install APK on PC by drag and drop file seer.computing.sqlfunctions_free_4_2485062.apk on Emulator screen
SQL Functions Reference (free) APK Pros & Cons [menu]
Pros
- This app is safe, it's not require high risk permissions
- Compatible with 32 bit device (most Emulator using 32bit arch CPU)
- Compatible with 64-bit device (some android device and current Bluestacks)
Cons
Everything is good.
