user_tab_columns
Where column_name = 'so _ type_id ';
5. Index:
Select * From dba_indexes; // index, including primary key index
Select * From dba_ind_columns; // index Column
Select I. index_name, I. uniqueness, C. column_name
From user_indexes I, user_ind_columns C
Where I. index_name = C. index_name
And I. table_name = 'Acc _ NBR '; // used for join
6. sequence:
Select * From dba_sequences;
7. View:
Select * From dba_views;
Select * From all_views;
Text can be used to query the scripts gener
@ anqing1 (Rac1)> conn DVD/DVD;
Connected.
DVD @ anqing1 (Rac1)> Create Table T1 (idnumber );
Table created.
DVD @ anqing1 (Rac1)> insert into t1values (1 );
1 row created.
DVD @ anqing1 (Rac1)> commit;
Commit complete.
DVD @ anqing1 (Rac1)> Create index idx_t1on T1 (ID );
Index created.
DVD @ anqing1 (Rac1)>
1. Use the Export Import command
1.1 export the data of a DVD user and generate a dump file
[Oracle @ Rac1 ~] $ Exp DVD/DVD file = DVD. dmpowner = DVD
Export: Release 10.2.0.4.0-producti
Label: Oracle current_schema Schema
User A contains the table TBL. If user a grants the access permission of TBL to user B (grant selectany table to B), you must reference the table of user a in user B, if you do not use synonyms, select * from. TBL;
A. the TBL format is because the TBL table belongs to the schema of user A. To make a metaphor, the schema (translation Scheme) is like a container that stores a series of database objects, which are des
sequenceSelect from any sequence in any scheme
Session permission
ReferenceCreate sessionCreate a session and log on to the database.Alter sessionRun the alter session Statement to change the session attributes.Alter Resource CostChange the computing resource consumption method in the Summary FileRestricted sessionConnect to data when the database is in restricted session Mode
Synonym permission
ReferenceCreate SynonymCreate and delete synonyms
out some of the keywords. However, the general amount of user reviews are very large, and the quality is uneven, so if the use of this method is more time-consuming and laborious, if there is enough, you can generally browse the list of competing reviews, perhaps there will be unexpected harvest.Keyword synonyms"Synonyms" Everyone is not unfamiliar, the key words also have
, then after the order of the scrambled these characters can get different information fingerprint.We are not difficult to find after the above points. Originally some SEO so-called pseudo-original method in Baidu seems to be so "pediatrics", the following several pseudo-original methods are not desirable:1. Adjust the order of stages: this is not much to say. A simple adjustment order is not a pseudo-original effect of whatever.2. Image Replacement method: I remember to have seen a site using t
Coreseek Actual Combat summaryThis article contains the following content:
Typical architecture of the Coreseek
Real-time Solutions
MMSEG participle Use experience
Experience with synonyms
Successor goals
Typical architecture of the CoreseekThe typical structure of coreseek is that the incremental index satisfies the approximate real-time, and the new records cannot be searched in time. For records that exist in the searc
automatic collection program, the collection, warehouse receiving, and pseudo-original processes can be implemented, and the entire process is unmanaged and real-time.
To change words without affecting the meaning of the document, a better method is to replace synonyms. so I thought the first step is to create a synonym Library. after searching for such a database online, I decided to search for related websites for collection and found that Kingsoft
11.2.0.1.0-ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from t; -- import successfulA----------1SQL>
3. Export all tables under the user (scott)[Oracle @ centos ~] $ Exp scott/system file = '/home/oracle/scott. dump '; -- import all the tables of scott (exp scott/system owner = user name file = 'path' -- export tables of other users)Export: Release 11.2.0.1.0-Production on Mon Feb 17 16:34:07 2014Copyright (c) 1982,200 9, Oracle and/or its
Timestamp and rowversion are the data types in SQL Server. They are synonyms, that is, the data types are the same.
In Enterprise Manager, we can only select timestamp as the column name, but in the T-SQL (such as the query analyzer), we can either use timestamp or rowversion.
So in the T-SQL, which one should we use? rowversion should be used. Because the timestamp defined by Microsoft is different from the timestamp defined in the ISO SQL-92, Micr
table area on the hashed cluster to save the region information.
Create cluster STCluster (Id NUMBER)SIZE 512 single table hashkeys 500;
Application Scenario 166: control the space usage of hash Clusters
Application Scenario 167: estimate the size of space required by the hash Cluster
Application Scenario 168: Modify and delete a hash Cluster
Application Scenario 169: view the hash function in the DBA_CLUSTER_HASH_EXPRESSIONS View
SELECT * FROM DBA_CLUSTER_HASH_EXPRESSIONS;
Use Case 170: Create
Oracle study notes 9 database objects, oracle Study NotesOracle database objects are also called schema objects. database objects are a set of logical structures, and the most basic database objects are tables. Other database objects include: synonym is an alias of an existing object. It has the following functions: 1. Simplified SQL statement 2. Hiding the Object Name and owner (hiding the original object content) 3. There are two types of public access syn
dictionary
The dictionary must be said at last. WordNet is a cognitive linguistics-based English dictionary designed by psychologists, linguists and computer engineers at Princeton University. It is not the light that arranges the words in alphabetical order and makes up a "network of words" in terms of the meaning of the words.
Introduction and synonymsMotorcar and automobile are synonyms, which can be studied with the help of WordNet.
/qq2013.10. Support for the recognition of Arabic/fractional basic word units, e.g. 2012, 1.75 m, 5 T, 120 kg, 38.6 ℃.11. Auto English fillet/half angle, uppercase/lowercase conversion.12. Synonym matching: Automatic Chinese/English synonyms append. (You need to turn on the Friso.add_syn option in Friso.ini).13. Automatic stop word filtering in English and Chinese. (You need to turn on the FRISO.CLR_STW option in Friso.ini).14. Multi-configuration sup
translation results will appear in the right pane. It also comes with a number of related examples, very practical (see Figure 1).
Figure 1
In addition, when doing Chinese-English articles, we sometimes use which English words are more suitable to handle. It would be nice to have a list of synonyms that are similar in meaning at this time. No problem! The synonym feature of Word is designed for this purpose. Select an English word, righ
corresponding translation results will appear in the right pane. It also comes with a number of related examples, very practical (see Figure 1).
Figure 1
In addition, when doing Chinese-English articles, we sometimes use which English words are more suitable to handle. It would be nice to have a list of synonyms that are similar in meaning at this time. No problem! The synonym feature of Word is designed for this purpose. Select an Engl
statements into sections.With a commit to confirm things.
Two. Data definition (DDL) section
1.CREATE (Create tables, indexes, views, synonyms, procedures, functions, database links, etc.)The types of fields commonly used by Oracle areCHAR fixed-length stringVARCHAR2 variable-length stringsNumber (M,n) M is the total number of digits, N is the length of the decimalDate Date Type
To create a table, place a smaller, not-empty field in front of it, p
more easily understand the link to the content of the page.
The correct formulation of anchor text is to use short descriptive text to avoid using text that is irrelevant to the subject of the target page, to avoid the long anchor text that is implemented with a long sentence or a short passage,
Keyword optimization
The layout of the key words, the most important position is the beginning, especially the first paragraph 50-150 words, the need to include a keyword, and then the middle of the t
object_type
-------------------------------------
public ogc_x synonym
Mdsys ogc_x FUNCTION
There is a ogc_x name function in the system, so from the above ORA-06553 error, it is true that this SQL statement executed this function, but why it was executed. Let's look at the definition of ogc_x. [Copy to Clipboard] View Code SQL
1
2
3
4
5
Sqlgt; Desc ogc_x;
Parameter Type Mode Default?
---------------------------------
replicated database
Export the main library BB data exp userid=bb/oracle@test file= '/home/oracle/bb1.dmp ' object_consistent=y rows=y [oracle@test admin]$ exp Use Rid=bb/oracle@test file= '/home/oracle/bb1.dmp ' object_consistent=y rows=y export:release 11.2.0.4.0-production on Thu Feb 1 21:42:43 2018 Copyright (c) 1982, Oracle and/or its affiliates.
All rights reserved. Connected to:oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production with the partitioning, OLAP, Da
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.