![]() If you are creating a synonym for a procedure or function on a remote database, then you must specify schema in this CREATE statement. If you do not qualify object with schema, then the database assumes that the schema object is in your own schema. SchemaSpecify the schema in which the object resides. Restriction on the FOR Clause The schema object cannot be contained in a package. The schema object need not currently exist and you need not have privileges to access the object. The schema object for which you are creating the synonym can be of the following types: Specify the object for which the synonym is created. See Also: "CREATE SYNONYM: Examples" and "Oracle Database Resolution of Synonyms: Example" Specify the name of the synonym to be created. You cannot specify a schema for the synonym if you have specified PUBLIC. If you omit schema, then Oracle Database creates the synonym in your own schema. Specify the schema to contain the synonym. If you do so, then all PL/SQL units that use that name will be invalidated. Take care not to create a public synonym with the same name as an existing schema. 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. Notes on Public Synonyms The following notes apply to public synonyms: A private synonym name must be unique in its schema. If you omit this clause, then the synonym is private and is accessible only within its schema. When resolving references to an object, Oracle Database uses a public synonym only if the object is not prefaced by a schema and is not followed by a database link. However each user must have appropriate privileges on the underlying object in order to use the synonym. Public synonyms are accessible to all users. Specify PUBLIC to create a public synonym. Restriction on Replacing a Synonym You cannot use the OR REPLACE clause for a type synonym that has any dependent tables or dependent valid user-defined object types. Use this clause to change the definition of an existing synonym without first dropping it. Specify OR REPLACE to re-create the synonym if it already exists. To create a PUBLIC synonym, you must have the CREATE PUBLIC SYNONYM system privilege.ĭescription of the illustration create_synonym.gif ![]() To create a private synonym in another user's schema, you must have the CREATE ANY SYNONYM system privilege. To create a private synonym in your own schema, you must have the CREATE SYNONYM system privilege. ![]() Notes at the bottom of a dictionary entry-especially usage notes and synonym studies-are often where we’ll find the detailed information that allows us to improve (or refine or polish ) our writing.See Also: Oracle Database Concepts for general information on synonyms Lists of synonyms are useful when we are struggling to write and looking for just the right word, but each word must be considered in light of its specific definition. The verbs make and construct mean roughly the same thing, but one is more likely to make a cake but construct a building, which is a more complex undertaking. A sunset might be described equally well as beautiful or resplendent, but a beautiful baby would not usually be described as resplendent, which implies an especially dazzling appearance. And when we move from nouns to other parts of speech, we almost always find subtle but important differences among synonyms: although the meanings overlap, they differ in emphasis and connotation. But forest and wood, though often interchangeable, have different shades of meaning: a forest tends to be larger and denser than a wood. And if you ask for a soda on the east coast of the U.S., you’ll get the same drink that asking for a pop will get you farther west. Just about every popular dictionary defines synonym as a term having “the same or nearly the same” meaning as another, but there is an important difference between “the same” and “nearly the same.” Noun synonyms sometimes mean exactly the same thing. English, with its long history of absorbing terminology from a wealth of other tongues, is a language particularly rich in synonyms -words so close in meaning that in many contexts they are interchangeable, like the nouns tongue and language in the first part of this sentence. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |