Oracle

What is the difference between oracle cold backup and hot backup? For oracle Database tutorial, only physical backup and logical backup are supported. Physical backup: A backup process that copies the operating system files that actually constitute

Last month's date: select last_day (add_months (sysdate,-1) from dual;Last second of the month: select trunc (add_months (sysdate, 1), 'mm')-1/24/60/60 from dualDate of the week: select trunc (sysdate, 'day') + 1 from dual Days from the beginning of

Exec and call usage When exec and call execute a procedure, DeclareS_in varchar2 (30): = 'where col = 13 '';V_ SQL _str varchar2 (200 );BeginV_ SQL _str: = 'select * from t1' | s_in;Execute immediate v_ SQL _str;End; Exec is a sqlplus command and

Oracle profile limits ORACLE usersThe PROFILE file of ORACLE is a method to restrict the resources used by database tutorial users. For example, you can control the CPU that can be used by sessions or SQL statements, and control your password

Here we have added a list of oracle functions that are helpful to ORACLE beginners. If you need them, you can check them out. Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ascii

This article briefly introduces the usage of the decode () function in oracle and illustrates the usage of this function in practical use using examples. In Oracle/PLSQL, the DECODE function has the IF-THEN-ELSE statement function. The syntax of the

This article introduces the usage of the Oracle trunc () function in the format of the TRUNC function. I have some experience now. When the format is day, it is only accurate to the day, regardless of the number of months in a few years, it is

This article describes how to switch the oracle physical standby database to read only and then switch back the specific operation methods and steps. I hope some methods will help you. To switch the physical standby database to the read only status,

This article introduces how to install and configure the oracle11g R2 database in Centos6. I hope this method will be helpful to you. 1. Install centos6.3 _ 64-bit: :

10gR2You need to convert a common table into monthly partitions to improve query efficiency.The test is as follows:1. Create a test table SQL T(ID ID T ROWNUM,CREATED TIMING () ( Ii.

Content Software Environment This example converts a number into a spelling.  Software Environment Windows Server 2008 R2 Oracle 11g Release 1 (11.1)  This example converts a number into a spelling. decode(sign(&num), -1, , 0, )

Note: The following operating environments are available in CentOS 6.4 + Oracle 11gR2 (Oracle is installed in ORACLE_BASE =/opt/oracle, and ORACLE_HOME =/opt/oracle/11g) After installing and configuring the Oracle database with OUI, Oracle is

Since we will look at ORACLE recursive queries, we should be clear about what recursion means. Here I will not explain it more, but I will just give a brief introduction. The so-called recursive query makes the data structure in the data table

From creating a simple table to implementing complex queries,   Drop table grade;Drop table item;Drop table sporter;Create table sporter (Sporterid NUMBER (4) primary key not null,Name VARCHAR (50) not null,Sex VARCHAR (2) not null,Department

                (1) normal user: SCOTT (password: tiger) (2) General Administrator: SYSTEM (password: manager) (3) Super administrator: SYS (password: change_on_install)   After Oracle is

Data Pump is a 10 Gb function, and personal inverted data prefers to use data pump. During the import, the remap parameter is used to easily convert the tablespace and schema, and the character set problem between the server and the client can be

Note that when multiple database instances are used, set ORACLE_SID = '', 1. Check whether sqlnet. ora (in the % ORACLE_HOME % NETWORKADMIN directory in WINDOWS) contains this sentence: SQLNET. AUTHENTICATION_SERVICES = (ETS). If not, add 2. Check

1. installation environment: Linux: Redhat Enterprise Linux 6.3 64-bit Oracle: Oracle Database 11 GB for Linux x86-64 64-bit 2. Modify core operating system parameters Perform the following steps under the Root user: Modify the user's SHELL

  [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

This article mainly analyzes the ORACLE system structure and working mechanism from four different levels of Adjustment Analysis on the large database ORACLE environment, and summarizes the nine different aspects comprehensivelyORACLE Database