This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:home [2009/12/04 02:41] tdo |
dev:sql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| ====== Omnidex SQL Quick Reference ====== | ====== Omnidex SQL Quick Reference ====== | ||
| - | ^[[ dev:sql:overview |Overview]]^ [[ dev:sql:statements:home | Statements]] ^[[dev:sql:functions:home | Functions ]]^ [[ dev:sql:select | SELECT ]]^ [[ nopage | Query Examples ]]^ | + | {{page>:sql_bar&nofooter&noeditbtn}} |
| + | |||
| ===== Most Common Statements ===== | ===== Most Common Statements ===== | ||
| Line 9: | Line 11: | ||
| * CREATE TABLE | * CREATE TABLE | ||
| * CREATE INDEX | * CREATE INDEX | ||
| + | |||
| + | ===== SQL Interfaces ===== | ||
| + | |||
| + | * JDBC | ||
| + | * ODBC | ||
| + | * Stored Procedures | ||
| ===== Omnidex SQL Tips ===== | ===== Omnidex SQL Tips ===== | ||
| Line 17: | Line 25: | ||
| Getting Counts. | Getting Counts. | ||
| + | ===== Learning Omnidex ===== | ||
| + | * [[ tutorials:simple_flatfile | Creating a very simple flat file Environment and doing retrievals. ]] | ||
| + | * [[ tutorials:simple_flatfile_java_JDBC | Writing a simple JDBC program to access the simple flatfile Environment. ]] | ||
| + | * [[ tutorials:simple_flatfile_cpp_ODBC | Writing a simple ODBC program to access the simple flatfile Environment. ]] | ||
| + | * [[ tutorials:simple_flatfile_EXCEL | Using EXCEL to access Omnidex Environments with the ODBC Driver. ]] | ||
| - | ===== Special Omnidex SQL Premitives ===== | + | ===== Special Omnidex SQL tokesns ===== |
| $omnidex - special table of one row and one column. Good to test functions, etc. | $omnidex - special table of one row and one column. Good to test functions, etc. | ||
| $uniquekey - | $uniquekey - | ||
| + | |||
| + | $ROWID - | ||
| ===== See Also ===== | ===== See Also ===== | ||