You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for SYNONYM


1 to 20 of 301 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

DROP SYNONYM

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 Prerequisites To drop a private synonym, either the synonym must be in your

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

5 Metadata

Synonym AttributesA parameter for a synonym (type PTYPE_SYN ) has the attributes described in Table 5-12.

SQL Reference, 10g Release 1 (10.1)

CREATE SYNONYM

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 … a user before the user can use the synonym. You can refer to synonyms in the following DML … : Oracle Database Concepts

Programmer's Guide, 10g Release 1 (10.1)

6 Describing Schema Metadata

Synonym AttributesWhen a parameter is for a synonym (type OCI_PTYPE_SYN), it has the attributes listed in Table 6-11 … id ub4 OCI_ATTR_SCHEMA_NAME A string containing the schema name of the synonym translation OraText … * OCI_ATTR_NAME A NULL -terminated string containing the object name of the synonym translation … OraText * OCI_ATTR_LINK A NULL

Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

SYNonym (SYN)Use the synonym operator ( SYN ) to expand a query to include all the terms that have been defined

SQL Reference, 10g Release 1 (10.1)

CREATE SYNONYM

Notes on Public SynonymsIf you create a public synonym and it subsequently has dependent tables or dependent valid user … -defined object types, then you cannot create another database object of the same name as the synonym in … the same schema as the dependent objects. Take care not to create a public synonym with the same … . schema Specify the schema

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

6 Managing Oracle Objects

Creating a Type SynonymYou create a type synonym with a CREATE SYNONYM statement. For example, these statements create a … type typ1 and then create a synonym for it: CREATE TYPE typ1 AS OBJECT (x number); / CREATE SYNONYMsynonym for a nested table type: CREATE TYPE typ2 AS TABLE OF NUMBER; / CREATE SYNONYM

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

6 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, 10g Release 1 (10.1)

3 Oracle Text 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. Syntax Syntax Description TRSYN( term [, lang, [ thes ]]) Expands term to include foreign equivalents of term, the synonyms of term, and the foreign equivalents of the synonyms.

Developer's Guide, 10g Release 1 (10.1)

18 Accessing Oracle XML DB Repository Data

Synonym Oracle XML DB Foldering Term UsageTable 18-1 Synonyms for Oracle XML DB Foldering Terms Synonym Oracle XML DB Foldering Term Usage

SQL Reference, 10g Release 1 (10.1)

16 SQL Statements: CREATE SYNONYM to CREATE TRIGGER

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

Security Guide, 10g Release 1 (10.1)

14 Implementing Application Context and Fine-Grained Access Control

How to Add a Policy to a Table, View, or Synonymyou to specify the table, view, or synonym to which you are adding a policy and various data … Procedure Purpose DBMS_RLS.ADD_POLICY Use this procedure to add a policy to a table, view, or synonym … . DBMS_RLS.DROP_POLICY Use this procedure to drop a policy from a table, view, or synonym … , view, or synonym.

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02075: materialized view on synonymlink. Action: Re-design the materialized view to avoid the use of the heterogeneous links. QSM-02075: materialized view on synonym

Error Messages, 10g Release 1 (10.1)

19 ORA-38029 to ORA-39961

ORA-38401: synonym string not allowedtaken up by some other object. Action: use the RENAME clause to recover the object with a different name. ORA-38401: synonym string not allowed

Error Messages, 10g Release 1 (10.1)

62 DRG-10000 to DRG-52210

DRG-11720: too many synonyms per synonym ringbest results DRG-11720: too many synonyms per synonym ring

Error Messages, 10g Release 1 (10.1)

62 DRG-10000 to DRG-52210

DRG-11713: multiple Preferred Terms per synonym ringonly one broader term DRG-11713: multiple Preferred Terms per synonym ring

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-22863: synonym for datatype string. string not allowedidentifier or leave it out of the statement. ORA-22863: synonym for datatype string. string not allowed

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02101: mv references a synonym in the FROM listviews. QSM-02101: mv references a synonym in the FROM list

Utilities, 10g Release 1 (10.1)

11 Conventional and Direct Path Loads

Loading into SynonymsYou can load data into a synonym for a table during a direct path load, but the synonym must point … directly to a table. It cannot be a synonym for a view, or a synonym for another synonym.

Reference, 10g Release 1 (10.1)

IND

INDis a synonym for USER_INDEXES. See Also: "USER_INDEXES"