This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:oracle:tables [2011/04/04 21:01] doc |
integration:rdbms:oracle:tables [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 55: | Line 55: | ||
| </code> | </code> | ||
| - | In the Omnidex declaration, note that the PHYSICAL clause for table points to the Oracle syntax of //user.table//. Also note that the columns use the PHYSICAL clause to point to the underlying Oracle column name, and use Omnidex datatypes rather than Oracle datatypes. | + | === Using the Table and Column PHYSICAL Clauses === |
| + | |||
| + | In the Omnidex declaration, note that the optional PHYSICAL clause for the table allows Omnidex to have a different table name than Oracle. This is most commonly used to allow a //user.table// designation for the Oracle table, but can also be used when administrators wish a different name in the Omnidex environment or need to shorten a table name to meet the 32-character limit in Omnidex. If the PHYSICAL clause is not present, Omnidex assumes that the table names are the same between Omnidex and Oracle. | ||
| + | |||
| + | Column declarations can similarly use a PHYSICAL clause to allow Omnidex to have a different column name than Oracle. | ||
| === Modifying Omnidex's View of the Oracle Data Objects === | === Modifying Omnidex's View of the Oracle Data Objects === | ||
| Line 61: | Line 65: | ||
| When Omnidex accesses a table, it only knows about the data objects that are declared in the Omnidex Environment File. It does not have an independent understanding of the Oracle environment. This allows administrators to shape the Omnidex Environment the way they want. Some of the opportunities this provides are: | When Omnidex accesses a table, it only knows about the data objects that are declared in the Omnidex Environment File. It does not have an independent understanding of the Oracle environment. This allows administrators to shape the Omnidex Environment the way they want. Some of the opportunities this provides are: | ||
| - | * Omnidex can have a controlled view of the Oracle database, limited to only the tables and columns that the application requires. | + | * Omnidex can have a controlled view of the Oracle database, limited to only the tables that the application requires. Similarly, administrators can choose to include only the columns for each table that the application requires. |
| * Omnidex tables can point to Oracle views, allowing an easy approach to reshaping the application's view of the data. | * Omnidex tables can point to Oracle views, allowing an easy approach to reshaping the application's view of the data. | ||
| + | * Omnidex can use different names for tables and columns by using the PHYSICAL clause in the TABLE or COLUMN sections of the CREATE TABLE statement to map to the underlying Oracle names. | ||
| * Omnidex columns can often be assigned datatypes that differ from the Oracle datatype. Character-class datatypes can be interchanged, allowing applications to easily receive the datatype that works best for its needs. Binary datatypes can be assigned to any of the integer or floating point datatypes; in fact, this is a necessity since Oracle's NUMBER datatype is only an internal datatype. | * Omnidex columns can often be assigned datatypes that differ from the Oracle datatype. Character-class datatypes can be interchanged, allowing applications to easily receive the datatype that works best for its needs. Binary datatypes can be assigned to any of the integer or floating point datatypes; in fact, this is a necessity since Oracle's NUMBER datatype is only an internal datatype. | ||
| * Omnidex tables can include [[admin:features:expressioncols:home|Expression-based Columns]], which are columns derived from a SQL expression rather than a specific column in the underlying database. | * Omnidex tables can include [[admin:features:expressioncols:home|Expression-based Columns]], which are columns derived from a SQL expression rather than a specific column in the underlying database. | ||