速報APP / 生產應用 / SQL Functions Reference

SQL Functions Reference

價格:免費

更新日期:2016-10-25

檔案大小:1.9M

目前版本:2.0

版本需求:Android 4.0 以上版本

官方網站:http://www.seercomputing.com

Email:apps@seercomputing.com

聯絡地址:142 Walter Road Swansea SA1 5RW United Kingdom

SQL Functions Reference(圖1)-速報App

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 ?

SQL Functions Reference(圖2)-速報App

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 …

SQL Functions Reference(圖3)-速報App

Number

String

SQL Functions Reference(圖4)-速報App

Date

Analysis

SQL Functions Reference(圖5)-速報App

Aggregate

Regex

SQL Functions Reference(圖6)-速報App

Timestamp

Misc

SQL Functions Reference(圖7)-速報App

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.

SQL Functions Reference(圖8)-速報App