Oracle

Trigger-related concepts and syntax Overview This blog post focuses on the following topics: What is a triggerApplication Scenarios for triggersSyntax for triggersTypes of TriggersCase Data: The concept of triggers and the first trigger A

Both date and timestamp are available for addition and subtraction operations.You can manipulate different time types for the current date Gagnin, month, day, hour, minute, and second, with three ways: 1 using built-in functions numtodsinterval add

Mathematics function 1. Absolute value Copy Code code as follows: S:select ABS ( -1) value O:select ABS ( -1) value from dual 2. Rounding (Large) Copy Code code as follows: S:select Ceiling ( -1.001) value

This article illustrates the method of Oracle to implement row and column conversion. Share to everyone for your reference, specific as follows: 1, the row and column conversion of fixed number Such as: Student subject Grade ---------------

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

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 most we deal with in Pl/sql programming is the stored procedure. The structure of the stored procedure is very simple, and we are here to learn some useful knowledge about how to write stored procedures in addition to the basic structure of the

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

Check the information on the internet for a few days, try to comprehensively clear the alarm log content and the way to build the external table to solve this problem. One: Back up and clear the alert log contents The daily alarm log is backed up

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

Duplicate data can be in two cases, the first: only some of the fields in the table, and the second is exactly the same as two rows of records. one, for partial field duplicate data deletion 1. Query for duplicate dataSelect field 1, Field 2, COUNT (

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