There are many interfaces in the current project, the data source may be different database or different users of the table, to access the table caused a certain amount of trouble. This time you can use synonyms to simplify.
The syntax for synonyms is: CREATE [OR REPLACE] [public] synonym [schema.] Synonym name for [schema.] Object [@dblink];
You also need assignment-related permissions when you create syno
Oracle Database SYNONYM (SYNONYM) Usage
This tutorial uses examples to illustrate how to create and delete Synonyms (SYNONYM) in Oracle Data ).
Concept
Synonyms refer to database objects (tables, views, sequences, stored procedures, and other database objects) referenced by another name. For example:
Creating a synonym
Tags: OCA must rom off system rtx syn change fromSynonyms: A synonym is an alias to another data object, the synonym is dependent on its target object, and the synonym becomes invalid if the target object is changed or deleted. Synonyms are not a substitute for the privileges of database objects, that is, the object with the schema is queried, executed, deleted,
It used to be that the synonym (synonym) in SQL Server was useless, so it never looked up its syntax format. Today, there is a problem, with synonym to solve the better. The problem is that I use multiple databases in my system, and because some of the data in each database needs to be synchronized, I add triggers to the tables in one of those databases to synchr
You can use multiple methods to back up synonyms. For example, you can use a script to generate a creation script for synonyms or use dbms_metadata.get_ddl to extract definition scripts for synonyms. However, when using the traditional exp or DataPump expdp for schema-level data migration, public synonyms cannot be exported. However, we can still use the Export and Import method. The difference is that we use the full = y method to export the synonym
1. Why use Synonyms:
Synonyms, as the name implies, mean that two words share the same meaning and can be replaced with each other. What are their functions:
A's most obvious goal is to simplify SQL. If the name of a database object is too long, you can create a shorter synonym, which is equivalent to the abbreviation.
B. another purpose is to hide the information of some objects. for example, to search for a table in another schema, you must add the
Oracle _ sequence, index, synonym, oracle SynonymZookeeper
1. Sequence1. sequence: database objects that can be used by multiple users to generate unique valuesUnique value automatically providedShared objectIt is mainly used to provide the primary key value.Loading Sequence values into memory improves access efficiency
2. create sequence statementCreate sequence sequence[Increment by n] -- the value of each increase[Start with n] -- START from[{MAXVA
Set synonyms for ease of use Select * from EMP; and so on are used for select * from ABC; Create a common synonymIf the user's level is not enough to establish a public synonym, You can authorize it under system: Grant create any synonym to Scott;Grant create public synonym to Scott; Cancel authorization: Revoke create any synoym from Scott;Revoke create public s
From a curious heart began to contact the network, with playing mentality to the catenary industry design, to love, like web design-I this way down, although the time is not long, but feeling pretty deep, here to talk about how I enrich my website ...
I contact the Internet very late: September 2003 began to touch the Internet (computer), that is what I just went to college is waiting, from learning QQ and play Games CS began, abandoned more than 2
Set synonyms to facilitate the use of select * fromemp; and so on for select * fromabc; create a common synonym if the user level is not enough to create a public synonym, you can
Set synonyms to make it easy to use select * from emp; and so on for select * from abc; create a common synonym. If the user level is insufficient, create a public
Set synonyms for ease of useSelect * from emp; and so on are used for select * from abc;Create a common synonymIf the user's level is not enough to establish a public synonym, You can authorize it under system:Grant create any synonym to scott;Grant create public synonym to scott;Cancel authorization:Revoke create any synoym from scott;Revoke create public synoym
July 11, 2015, although has been working for three years, but has never worked out to enrich their own plans, even if there is no plan, but I did not give up in the bottom of my heart. Remember when the primary school, there is a teacher of music, the first time I see him is very old, fifty or sixty-year-old appearance, now memory of his appearance is still (said a bit more), he said a sentence I still remember the words: There are volunteers, Li Long
How to enrich the content options of win10 right menu ?, Win10 menu
Microsoft added many features when win10 was launched, one of which is about the right menu. We know that Microsoft's default right-click menu function is relatively limited, so we can manually dig out some new useful functions.
First, go back to the desktop and press "Win + R" to open the "run" window. Here, enter:
Regedit
After entering the information, click OK"
Open Regi
Enrich your JavaScript library each good developer will form its own class library, and as a Java developer, we will also write a bunch of tools to simplify our development efforts. But as a full-station siege Lion, not just understand the formation of Java class Library, JavaScript class library is equally important. Well, this article does not say much nonsense, the following code provides some very convenient tool classes, or is the extension of Ja
ITerm-enrich your command lines
Today we will introduce you to a tool:iTerm. This time we are talking about development technology, but it is just a tool. However, although it is a tool, it can improve your skill level. Let's take a look at it. Every developer will inevitably use the command line.gitVersion library operations, to run some scripts, are inseparable from the command line. Although the graphic interface is very powerful, in many cases, us
webmaster significance. For Baidu keyword ranking stability problem, the organ wolf also wrote a "when the keyword has a good ranking, how to make the ranking more lasting?" ", Today, the wolf to share with you, grassroots webmaster should be how to avoid a single relying on Baidu keyword rankings to obtain traffic!" that is to enrich your website traffic source! Multi-channel access to the flow of general ideas are as follows: (only a few main, the
Introduction: This is a PHP developer: enrich the detailed page of your xml toolkit. It introduces PHP, related knowledge, skills, experience, and some PHP source code.
Class = 'pingjiaf' frameborder = '0' src = 'HTTP: // biancheng.dnbc?info/pingjia.php? Id = 326932 'rolling = 'no'>
PHP's support for XML is increasing with the popularity of PHP. You can find nearly a dozen XML tools available by PHP developers from this article. Tool consultant Cr
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.