This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:overview [2010/05/12 20:14] tdo |
dev:sql:overview [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| Omnidex SQL is based on ANSI SQL, but also contains extensions that support Omnidex's extended features. | Omnidex SQL is based on ANSI SQL, but also contains extensions that support Omnidex's extended features. | ||
| - | Omnidex has limited support Oracle and SQL Server specific SQL extensions such as Oracle decode. | + | Omnidex has limited support for Oracle and SQL Server specific SQL extensions such as Oracle decode. |
| - | Omnidex SQL is availabler using standard ODBC and JDBC connections. | + | Omnidex SQL is available using standard ODBC and JDBC connections. |
| Omnidex provides a high-level SQL interface to access databases enhanced with Omnidex indexes. The SQL supported is a subset of the ANSI SQL2 and ANSI SQL99 standard along with some very powerful extensions specific to Omnidex. | Omnidex provides a high-level SQL interface to access databases enhanced with Omnidex indexes. The SQL supported is a subset of the ANSI SQL2 and ANSI SQL99 standard along with some very powerful extensions specific to Omnidex. | ||
| Line 25: | Line 25: | ||
| Omnidex SQL statements can also be tested and scripted using the [[programs:odxsql:overview|OdxSQL]] program. | Omnidex SQL statements can also be tested and scripted using the [[programs:odxsql:overview|OdxSQL]] program. | ||
| - | |||
| - | ===== Omnidex Statements ===== | ||
| - | ===== Omnidex Functions ===== | ||
| - | |||
| - | |||
| - | |||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||