This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:oracle:queries [2011/04/04 02:51] doc |
integration:rdbms:oracle:queries [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| [[integration:rdbms:oracle:databases|Databases]] | | [[integration:rdbms:oracle:databases|Databases]] | | ||
| [[integration:rdbms:oracle:tables|Tables]] | | [[integration:rdbms:oracle:tables|Tables]] | | ||
| + | [[integration:rdbms:oracle:constraints|Constraints]] | | ||
| [[integration:rdbms:oracle:datatypes|Datatypes]] | | [[integration:rdbms:oracle:datatypes|Datatypes]] | | ||
| - | [[integration:rdbms:oracle:indexes|Indexes]] | | ||
| **[[integration:rdbms:oracle:queries|Queries]]** | | **[[integration:rdbms:oracle:queries|Queries]]** | | ||
| [[integration:rdbms:oracle:updates|Updates]] | | [[integration:rdbms:oracle:updates|Updates]] | | ||
| Line 30: | Line 30: | ||
| === Oracle-specific Syntax === | === Oracle-specific Syntax === | ||
| - | Omnidex requires that all statements use Omnidex SQL syntax. Omnidex SQL uses ANSI SQL as a base, but also allows extensions from various database, as well as Omnidex-specific extensions. If the statement, [[dev:sql:statements:set_sqlsyntax:home|SET SQLSYNTAX ORACLE]] is issued, then Omnidex SQL will also support these Oracle-specific functions: | + | Omnidex requires that all statements use Omnidex SQL syntax. Omnidex SQL uses ANSI SQL as a base, but also allows extensions from various databases, as well as Omnidex-specific extensions. If the statement, [[dev:sql:statements:set_sqlsyntax:home|SET SQL_SYNTAX ORACLE]] is issued, then Omnidex SQL will also support these Oracle-specific functions: |
| * [[dev:sql:functions:chr|CHR]] | * [[dev:sql:functions:chr|CHR]] | ||
| Line 48: | Line 48: | ||
| ===== ===== | ===== ===== | ||
| - | **[[integration:rdbms:oracle:indexes|Prev]]** | | + | **[[integration:rdbms:oracle:datatypes|Prev]]** | |
| **[[integration:rdbms:oracle:updates|Next]]** | **[[integration:rdbms:oracle:updates|Next]]** | ||