SQL Server and Oracle Integration

Quick Links

Omnidex QuickLinks

Omnidex SQL	Overview	Statements	Functions	Examples	Quick Ref
OdxSQL	Overview	Commands	Settings	Command Line	Quick Ref
Programs	OdxSQL	OdxNet	OdxAim	versions
Legacy Progs.	oacomp	dbinstal	oahelper	oadecomp	Legacy Env. Syntax
Data Stores	Raw data files	Oracle	SQLServer	MySQL	ODBC
Datatypes	Omnidex	Oracle	SQLServer	MySQL	ODBC
DDL Create	Create Env.	Create Database	Create Table	Create Index	Create Index Group
DDL Drop	Drop Env.	Drop Datebase	Drop Table	Drop Index	Drop Index Group
SQL DML	Select	Insert	Delete	Update	Qualify
SQL Access	Connect ¹	Disconnect ¹	Attach	Detach	Set
SQL Syncing	Update Indexes	Update Text	Update Statistics	Update Rollups	Update Rollup Table
SQL Special	Export	Partition	Join	Open Cursor	Close Cursor
SQL Other	Install Indexes	Remove Indexes	Load OFX	Command	Extract ²
SQL Functions	Standard	Extended	Oracle	String	Adv. Text
Special	Env Variables	Glossary	Debugging	Conn Strings	Release Notes
Interfaces	ODBC	JDBC	Oracle Stored Procs	SQL Stored Procs.
Languages	Java	C#	PHP	C++	OA/CLOA Libraries
Features	Snapshots	Grids	Rollup Tables	Geo Searches
Indexing	Concepts	Options	Strategies	Updates	Explain Plans
Indexing	ActiveCounts	PowerSearch	AutoComplete	Omnidex Text	Adv. Strategies
————————–	————————–	——————————–	——————————–	——————————–	——————————–

¹ The CONNECT and DISCONNECT statements are used in OdxSQL. Specific connection methods are used in ODBC/JDBC.
² The EXTRACT command is only available in the OdxSQL program.

Back to top

rdbms/proprietary/intro/sqlserver_oracle.txt · Last modified: 2012/10/26 14:57 (external edit)

Sitemap Recent Changes