Oracle

Trigger used: 　　 Drop sequence users_tb_seq; Create sequence users_tb_seq minvalue 1 maxvalue 99999 Increment by 1 Start with 1; Create or replace trigger users_tb_tri Before insert on users For each row Begin Select users_tb_seq.nextval

When using the SQL server syntax to write oracle stored procedures, errors may occur. The other differences are as follows. Two methods for creating a stored procedure in oracle Create or replace procedure getdefault isBegin Execute immediate

Oracle Database tutorial cursor usage 1. What is a cursor? A cursor is a PL/SQL control structure that allows you to control the display of SQL statements to facilitate the processing of table data one by one. 2. cursor Classification Display cursor:

1. Constraints 2. External Connection 3. View 4. conversion functions To_char converts the parameter to a string. To_char (date | represents the date string, 'format') is expressed in a certain format To_char (hiredate, 'dd') = '03' To_date parses

Check the concept on the bus. The oracle lock mechanism is somewhat different from MSSQL. Take the time to sit down and test it. Oracle uses the lock mechanism to provide data concurrency, consistency, and integrity between transactions. These

First, refer to the official documentation: http://docs.oracle.com/cd/B28359_01/install.111/b32002/install_overview.htm If you are not a ULN customer, and you are running Red Hat Enterprise Linux or Oracle Linux, then you can obtain the Oracle

Before installation, note: Install the environment in this article: install the required package (under the root account ): binutils-..-libstdc++--.-libstdc++--. (-libelf--libelf-devel--.-c++-.---- (-common--devel--devel- (-headers---.-.

1. Modify the Oracle field type/* modify the original field name */Alter table name rename column field name TO field name 1;/* Add a field with the same name as the original field */Alter table name ADD field name VARCHAR2 (30 );/* Update the

1. first, query the daily redo log switching frequency, locate the abnormal time point, and perform rough filtering to calculate the log volume. (even if the program problem cannot be solved, you can temporarily expand the disk capacity, first, let

  [Terry Note] backup http://www.cnblogs.com/kkterry/p/3308405.html for RMAN Integrated Learning [Terry Notes] recovery http://www.cnblogs.com/kkterry/p/3308407.html for RMAN Integrated Learning [Terry Note] configuration

  Flashback has two main functions: flashback query and flashback table/database)Enable the flashback function (you can enable database flashback only after archiving) name,flashback_on v$; system db_recovery_file_dest_size; system db_recovery_

The following is a detailed analysis of the three methods for creating an Oracle database. For more information, see 1. Create, configure, or delete a Database by running Oracle Database Configuration Assistant (you can also enter dbca in the

After Oracle is installed, there is a default database. In addition to this default database, we can also create our own database. For beginners, you can use the 'database Configuration asmap' Wizard to create a Database to avoid troubles. After

Data Guard provides two services:1) Redo transmission service: Transfers Redo logs of Primay to one or more Standby destinations.2) Redo Application Service: The Redo log transmitted from Primay on the Standby side.This article describes the Redo

What is the difference between DELETE and TRUNCATE? Delete, truncate, They all delete the data in the table, but cannot delete the table structure. delete can delete the data of the entire table or delete one or more data that meet the conditions

Stateless HTTP protocol 1. Advantages and Disadvantages of stateless HTTP protocol A) HTTP interaction is stateless. Stateless means that when a browser sends a request to the server, the server responds, but the same browser sends the request to

Create test tables, which are frequently used by DBAs. Generally, they are created based on dba_objects. This article is based on the big_table of Master Tom for your reference.1. big_table based on Oracle 10 GB --====================================

1. log on to the database using an oracle user [Oracle @ wuzj ~] $ Sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Thu Feb 26 12:06:29 2009 Copyright (c) 1982,200 5, Oracle. All rights reserved. SQL> conn/as sysdba Connected. // View the

Many netizens are putting the REDO01 ~ 03. After the three redo logs are deleted, the database cannot be logged on normally. The following example shows the specific recovery process, hoping to solve the problem for you: I: C:/> sqlplus/nolog II:

1. The tested statements must be exactly the same as those in the shared pool. 2. Variable names should be as consistent as possible 3. Rational use of external connections 4. Use less multi-layer nesting 5. Multi-purpose concurrency Statement