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.