Synonym Attributes → When a parameter is for a synonym (type OCI_PTYPE_SYN), it has the attributes listed in Table 6-11 … OCI_ATTR_OBJID Object id ub4 OCI_ATTR_SCHEMA_NAME A string containing the schema name of the synonym translation … text * OCI_ATTR_NAME A -terminated string containing the object name of the synonym translation … text * OCI_ATTR_LINK
SYNonym (SYN) → Use the synonym operator ( SYN ) to expand a query to include all the terms that have been defined in a thesaurus as synonyms for the specified term.
Synonym Attributes → A parameter for a synonym (type PTYPE_SYN ) has the attributes described in Table 6-12. Table 6-12 … unsigned int ATTR_SCHEMA_NAME Null-terminated string containing the schema name of the synonym … translation string ATTR_NAME Null-terminated string containing the object name of the synonym translation … string ATTR_LINK Null-terminated
DROP SYNONYM → Purpose Use the DROP SYNONYM statement to remove a synonym from the database or to change the … definition of a synonym by dropping and re-creating it. See Also: CREATE SYNONYM for more information on synonyms
CREATE SYNONYM → Purpose Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a … object, user-defined object type, or another synonym. Synonyms provide both data independence and … before the user can use the synonym. You can refer to synonyms in the following DML statements
Using a Type Synonym → You can use a type synonym anywhere that you can refer to a type. For instance, you can use a type … synonym in a DDL statement to name the type of a table column or type attribute. In the following … example, synonym syn1 is used to specify the type of an attribute in type typ3: CREATE TYPE typ1 AS … OBJECT (x number); CREATE
Translation Term Synonym (TRSYN) → Use the translation term operator ( TR ) to expand a query to include all the defined foreign equivalents of the query term, the synonyms of query term, and the foreign equivalents of the synonyms.
Creating a Type Synonym → You create a type synonym with a CREATE SYNONYM statement. The statement has the following syntax … : CREATE [OR REPLACE] [PUBLIC] SYNONYM [.] FOR [.][@]; where is a user-defined type. For example … , these statements create a type typ1 and then create a synonym for it: CREATE TYPE typ1 AS OBJECT (x … number);
Synonym Support for Table Names → A synonym can be used instead of a table name for any table_name input parameter, as explained in Section 1.9.
15 SQL Statements: CREATE SYNONYM to CREATE TRIGGER → This chapter contains the following SQL statements: CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TEMPORARY TABLESPACE CREATE TRIGGER
SP2-0749 Cannot resolve circular path of synonym synonym_name → Cause: An attempt was made to use a synonym to point to an object that no longer exists where the … synonym had the same name as the base object, or an attempt was made to use a synonym that has a … circular path that points back to itself. Action: Make sure that the last synonym in the synonym path
SDO_LRS.CLIP_GEOM_SEGMENT Clips a geometric segment (synonym of SDO_LRS.DYNAMIC_SEGMENT). → the start point and end point. SDO_LRS.CLIP_GEOM_SEGMENT Clips a geometric segment (synonym of SDO_LRS.DYNAMIC_SEGMENT ).
Examples → CREATE SYNONYM Examples To define the synonym offices for the table locations in the schema hr … , issue the following statement: CREATE SYNONYM offices FOR hr.locations; To create a PUBLIC synonym for … : CREATE PUBLIC SYNONYM emp_table FOR email@example.com; A synonym
CREATE TRIGGER → Purpose Use the CREATE TRIGGER statement to create and enable a database trigger, which is A stored PL/SQL block associated with a table, a schema, or the database or An anonymous PL/SQL block or a call to a procedure implemented in PL/SQL or Java Oracle automatically executes a trigger when specified conditions occur. When you create a trigger, Oracle enables it automatically. You can subsequently
subpartition_by_list::=, subpartition_by_hash::=, range_values_clause::=, table_partition_description::= → subpartition_by_hash::= Text description of subpartition_by_hash
segment_attributes_clause::=, data_segment_compression::=, LOB_storage_clause::=, varray_col_properties::=,… → partition_level_subpartition::= Text description of partition_level_subpartition
CREATE TEMPORARY TABLESPACE → Purpose Use the CREATE TEMPORARY TABLESPACE statement to create a locally managed temporary tablespace, which is an allocation of space in the database that can contain schema objects for the duration of a session. If you subsequently assign this temporary tablespace to a particular user, then Oracle will also use this tablespace for sorting operations in transactions initiated by that user. To create
Prerequisites → You must have the CREATE TABLESPACE system privilege.
( datafile_tempfile_spec::=, temp_tablespace_extent::= ) → temp_tablespace_extent::= Text description of temp_tablespace_extent