Oracle

1. Define constraints when you build a table, either at the column level or at the table level. For a NOT NULL constraint, it can only be defined at the column level and cannot be defined at the table level. (1) Column-level definition Grammar:

# Legal Oracle Identification symbol 1, cannot be reserved keyword 2, must use 1 to 30 characters. The name of the database is up to 8 characters. 3, must start with the letter character in the database character set 4. Can only contain

Well, I also Finon, because in the company's year-end goal of writing to learn Oracle, today began Oracle, to give you a new understanding of it! Not going to hit me! ~ Quack. Actually, to be honest, I don't want to write theory in this respect,

In the analysis of the relationship between V$tempfile and V$sort_usage, we notice that Oracle's allocation rules and regular data files are not the same for the absolute file number (AFN) of the temporary file. In fact, the absolute file number of

This technical article, provided by the International Oracle User Group (IOUG), is a user-organized organization that enhances the level of Oracle database experts and database developers by providing high-quality information, training, networking,

The purpose of this article: 1. Say something about Oracle's optimizer and its related knowledge. 2, answer why sometimes a table of a field is clearly indexed, when the observation of some SQL execution plan, found that the problem does not go to

Use of index clusters: Create clusters of tables that are often accessed in connection statements. Do not cluster tables if the tables are only occasionally connected or their public columns are often modified. (It takes more time to modify the

In order to be successful, I'll involve some preliminary steps that will be needed to see what happens, including running Plustrce SQL scripts, creating a Explain_plan table, granting roles, configuring Sql*plus environments to view execution plans.

The new feature of ORACLE11G's automatic memory management (Automatic Memory Management) is another important enhancement of Oracle's memory management. If this parameter is set too high, the following error prompts may appear when the instance is

Is it difficult to accurately allocate the amount of memory required for different pools? The automatic shared memory management feature makes it possible to automatically allocate memory to where it is most needed. Whether you're an entry-level

Paging Query format: SELECT　*　FROM ( SELECT　A.*,　ROWNUM　RN FROM　(SELECT　*　FROM　TABLE_NAME)　A WHERE　ROWNUM　 ) WHERE　RN　>=　21 The most inner query select * FROM table_name represents the original query statement without paging. RowNum = 21 control

Conditions for inserting a view: 1. If the view is based on a base table, then this is called a connectionless view, and all of the disconnected views are updatable, that is, you can do it on the view, Insert,update,delete the operation. 2. If you

Oracle's spatial database operation driver updated, the new driver for Oracle8.0 or above, the new driver in the database operation above and the original driver difference is larger, but one thing: the use of simpleThe steps to build a spatial

Environment: WinXP, iReport1.2.8, Oracle 10g databaseAfter installation completes iReport1.2.8, when making database connection, the Oracle 10g database is connected by JDBC, the connection is set up as follows: The above configuration is correct,

Odp.net 11g is an Oracle-released Ado.net component for. NET programs to access Oracle databases, better performance than Microsoft's own Oracle components, more access to the UDT (User Defined type) type, Procedure, Ref and so on advanced Oracle

To test the creation of a data guard environment on the same server. The main library is in a normal state and there are available backups, and the force logging and associated initialization parameters for the main library are set below: sql>

Use tablespace point-in-time Restore (TSPITR) to restore one or more non-system tablespaces to a point in time different from the rest of the database. This is a bit like the flashback. For example, the user mistakenly deleted 3 sheets, we can use

Oracle's Range,hash,list three major partitions Maybe we're all familiar with it, but what each partition applies to what scenario may be a lot of people's puzzles, what should be noted when choosing a different partition, why, and what needs to be

A few days ago, a friend of the group said DB in the beginning of backup mode after shutdown not come up, today said backup recovery test a bit, found that can be up, but the production environment or to pay attention, it is best not to do so. sql>

Rman backed up db when: Waiting for snapshot control file Enqueue prompt, rarely see this hint, recorded. Rman> run{ 2> backup Database; 3> Delete noprompt obsolete; 4> backup Archivelog all; 5>} Starting backup at 2011-09-30 15:31:00 Using