Oracle

This article mainly discusses the following kinds of index access methods: 1. Indexing unique Scan (Index unique SCAN)2. Indexing range Scan (Index range SCAN)3. Index full Scan (SCAN)4. Indexing skip Scan (index skipping SCAN)5. Index fast full

The Oracle tutorial being looked at is: Oracle Database Security Policy Analysis (ii). Security for the SQL*DBA command: If you do not have a sql*plus application, you can also use SQL*DBA to do SQL check permissions, which can only be assigned to

The Oracle tutorial you are looking at is: Oracle Database Security Policy Analysis (iii). security Policy for data: Data should be considered based on the importance of data. If the data is not very important, then the security policy of the

DB Storage Hierarchy (Drawing a sketch, will take a look ...) XD) Managing Table Spaces -system Storing data dictionary information, it is necessary to create a database when creating the first -sysaux 10g new, necessary, auxiliary sharing

This article to share the Oracle trunc function processing date format related knowledge, very has the reference value, concrete please see below explanation. Copy Code code as follows: Select To_char (sysdate, ' Yyyy-mm-dd

The Oracle tutorial you are looking at is the Oracle database operations skills set. [Editor's note:] to bring up the database, the first company to think of, is usually Oracle (Oracle company). Oracle has a leading position in the database field.

The Oracle tutorial being looked at is: Oracle SQL Performance Tuning series learning one. 1. Choose the appropriate Oracle OptimizerThere are 3 Oracle optimizer types:A. Rule (rule-based) b. Cost (based on costs) c. CHOOSE (optional)Set the default

The Oracle tutorial you are looking at is: a brief discussion of Oracle database set replication methods. Objective The growing demand for distributed applications requires a better distributed software environment, which drives the development of

When we do not care about the loss of database data, change, the database objects need to do based on point-in-time recovery, to find the data we need, this point can not be accurate to determine the timing of the Oracle log to be analyzed, and get

The Oracle tutorial you are looking at is optimizing Oracle downtime and database recovery. 　 The steps to minimize Oracle downtime are discussed here. All forms of downtime-planned or unplanned-always occur,A DBA should have the correct backup

Delete a large table when the space is not released, very slow because of a large amount of system resources, support fallback operation, space is also occupied by this table. TRUNCATE TABLE name (frees table space when records are deleted from a

Since 9i, Oracle Dataguard generally do not need to manually process the lost log, FAL will automatically help us deal with, the following case by hand to handle the Lost log method: 1. What logs are missing from the standby query and not applied

The Reset method is as follows: Open the cmd command prompt, and then enter the following command to reset: Input Sqlplus/nolog, carriage return Sql> Conn/as SYSDBA is connected; Sql>alter user system identified by "123456"; ---(123456 is the

First, overview:Blocking is a common scenario for DBAs, especially the blocking caused by poor application design, which can result in a severe degradation of database performance until the database crashes. For DBAs, it is necessary to know how to

In the application of data insertion through a group of SQL statements, we are likely to encounter situations where we need to insert large data, for example, when we need to insert a field with more than 4000 bytes in Oracle, if we implement the

INSTR (source string, target string, start position, match ordinal) In Oracle/plsql, the InStr function returns the position of the string to be intercepted in the source string. Retrieves only once, that is, from the beginning of the character to

Instead of using a select in a stored procedure like SQL Server, Oracle can return a result set, which is returned by a result set of an out type parameter. is actually using ref CURSOR Copy Code code as follows: --procedure returns the

I. Basic query statements, Special symbols | | Make column aliases as, uniquely labeled distinct 1. Character Connector "| |" and "+" characters Oracle:select Column name | | ' 111111111111111 ' from table nameSql:select column name + ' 11111111111

1. Overview of Views A view is actually a query SQL statement that displays related data in one or more tables or other views. The view uses the results of a query as a table, so the view can be viewed as a stored query or a virtual table. Views

first, the concept 1. Databases (database) What is a database? The database is organized according to some data model and holds the data collection in level two memory. This data set has the following characteristics: As far as possible without