How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
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 Prerequisites To drop a private synonym, either the synonym must be in your
Synonym Attributes → A parameter for a synonym (type PTYPE_SYN ) has the attributes described in Table 5-12.
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 … a user before the user can use the synonym. You can refer to synonyms in the following DML … : Oracle Database Concepts
Synonym Attributes → When 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
SYNonym (SYN) → Use the synonym operator ( SYN ) to expand a query to include all the terms that have been defined
Notes on Public Synonyms → If 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
Creating a Type Synonym → You 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 SYNONYM … synonym for a nested table type: CREATE TYPE typ2 AS TABLE OF NUMBER; / CREATE SYNONYM
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. 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.
Synonym Oracle XML DB Foldering Term Usage → Table 18-1 Synonyms for Oracle XML DB Foldering Terms Synonym Oracle XML DB Foldering Term Usage
16 SQL Statements: CREATE SYNONYM to CREATE TRIGGER → This chapter contains the following SQL statements: CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TRIGGER
How to Add a Policy to a Table, View, or Synonym → you 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.
QSM-02075: materialized view on synonym → link. Action: Re-design the materialized view to avoid the use of the heterogeneous links. QSM-02075: materialized view on synonym
ORA-38401: synonym string not allowed → taken up by some other object. Action: use the RENAME clause to recover the object with a different name. ORA-38401: synonym string not allowed
DRG-11720: too many synonyms per synonym ring → best results DRG-11720: too many synonyms per synonym ring
DRG-11713: multiple Preferred Terms per synonym ring → only one broader term DRG-11713: multiple Preferred Terms per synonym ring
ORA-22863: synonym for datatype string. string not allowed → identifier or leave it out of the statement. ORA-22863: synonym for datatype string. string not allowed
QSM-02101: mv references a synonym in the FROM list → views. QSM-02101: mv references a synonym in the FROM list
Loading into Synonyms → You 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.