oracle
SQL Update
Added new entries to the expanding SQL section. The new sections separate the Datatypes and Functions into the correct groups. Updates to come will include pages on how to script them within each DBMS through SQL.
String/Text Datatypes
String data types hold a series of readable characters. These strings store values in plain text and should not be used for critical data unless it is encrypted. However, string datatypes can hold as little as a single character or several gigabytes depending on the type that is used. DATA TYPE SYMPLE TYPE Database DESCRIPTION [...]
Numeric Datatypes
Numeric datatypes hold any integer or decimal numerical value. Some DBMS have specialized fields that are formatted however in most cases any formatting must be handled through a special command in SQL or in the recipient language. DATA TYPE SYMPLE TYPE Database DESCRIPTION TINYINT(N) NUMERIC SQL Server, MySQL -128 TO 127 NORMAL. 0 TO [...]
Enumerated Datatypes
Each DBMS handles enumeration differently. The following datatypes are only available on MySQL. The other systems allow for custom datatypes or require a separate table to handle enumeration. It is important to know that these are there and available on some systems. DATA TYPE SYMPLE TYPE Database DESCRIPTION ENUM(X,Y,Z,ETC.) ENUMERATED MySQL LET YOU ENTER [...]
Datetime Datatype
Datetime datatypes are used to store date or time information within the database. Most types are available on all DBMS however some have more precision then others. DATA TYPE SYMPLE TYPE Database DESCRIPTION DATE DATETIME SQL Server, MySQL, Oracle, PostgreSQL A DATE. FORMAT: YYYY-MM-DD NOTE: THE SUPPORTED RANGE IS FROM ’1000-01-01′ TO ’9999-12-31′ DATETIME [...]
Binary Datatypes
Binary Datatypes are used to store binary data such as documents, images, or encrypted data. The most common usage is to store files within the database. This has the benefit of keeping them in a dynamic location without needing to constantly update links or locations. DATA TYPE SYMPLE TYPE Database DESCRIPTION BLOB BINARY MySQL FOR [...]
Math Functions
Mathematical Functions are critical for any application. This is because they can manipulate the different values stored in the database prior to outputting them. The functions can also be used to preprocess data that can be then inserted into a table or query for later usage. Function Database Return Data Type Description ABS SQL Server, MySQL, [...]
Conversion Functions
Conversion Functions are used to change from one data type to another. They can also be used to extract valuable information from a string or stringified array. The following is a list of the most common functions. It is important to know that SQL Server has several useful functions that are not available in other [...]
Data Types
There are different data types for the RDBMS and the following lists most of them. It is also important to understand that if a database does not have a specified type it will try to CAST it dynamically to the correct field time. Binary Datatypes Datetime Datatypes Enumerated Datatypes Numeric Datatypes String Datatypes
