Results for SYNONYM


1 to 20 of 438 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

SYNONYMSYSDATE TABLE *

Programmer's Guide, 9i Release 2 (9.2.0.2)

Describing Schema Metadata

Synonym AttributesWhen 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

Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

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.

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

Metadata

Synonym AttributesA 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

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 3 of 19

DROP SYNONYMPurpose 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

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 2 of 6

CREATE SYNONYMPurpose 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

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Managing Oracle Objects

Using a Type SynonymYou 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

Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

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.

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Managing Oracle Objects

Creating a Type SynonymYou 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);

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

New and Changed Features

Synonym Support for Table NamesA synonym can be used instead of a table name for any table_name input parameter, as explained in Section 1.9.

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 1 of 6

15 SQL Statements: CREATE SYNONYM to CREATE TRIGGERThis chapter contains the following SQL statements: CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TEMPORARY TABLESPACE CREATE TRIGGER

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0749 Cannot resolve circular path of synonym synonym_nameCause: 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

Spatial User's Guide and Reference, 9i Release 2 (9.2.0.2)

Linear Referencing Functions

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 ).

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 2 of 6

ExamplesCREATE 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 oe.employees@remote.us.oracle.com; A synonym

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 6 of 6

CREATE TRIGGERPurpose 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

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 3 of 6

subpartition_by_list::=, subpartition_by_hash::=, range_values_clause::=, table_partition_description::=subpartition_by_hash::= Text description of subpartition_by_hash

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 3 of 6

segment_attributes_clause::=, data_segment_compression::=, LOB_storage_clause::=, varray_col_properties::=,…partition_level_subpartition::= Text description of partition_level_subpartition

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 5 of 6

CREATE TEMPORARY TABLESPACEPurpose 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

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 5 of 6

PrerequisitesYou must have the CREATE TABLESPACE system privilege.

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 5 of 6

( datafile_tempfile_spec::=, temp_tablespace_extent::= )temp_tablespace_extent::= Text description of temp_tablespace_extent





Was this page helpful?

Integrated Cloud Applications & Platform Services