skip to main content
About the Driver : Using the driver : Views and Remote/Local Tables
  

Try DataDirect Drivers Now

Views and Remote/Local Tables

You can create views with the Create View statement. A view is like a named query. The view can refer to any combination of remote and local tables as well as other views.
You can create a remote or local table using the Create Table statement. A remote table is an Oracle Service Cloud object and is exposed in the RIGHTNOW schema. A local table is maintained by the driver and is local to the machine on which the driver is running. A local table is exposed in the PUBLIC schema.
See Supported SQL Statements and Extensions for details on the Create View and Create Table statements and other SQL statements supported by the driver.