Oracle

The data guard provides the following three kinds of protection modes: 1 Maximum protection mode (Maximum Protection) "Maximum protection" here refers to the maximum protection of the data is not lost, that is, at least one standby and primary

The Oracle tutorial you are looking at is: Oracle SQL Performance Tuning Series Learning Ii. 4. Select the most efficient table name order (valid only in the Rule-based optimizer) The Oracle parser processes the table names in the FROM clause in

Oracle date functions are used to process dates and times in an Oracle database, and the following is a detailed introduction to the use of Oracle date functions in the hope of enlightening you. (1) Sysdate and trunc Two Oracle date functions take

The Java Database Connectivity (JDBC) API is a series of interfaces that enable Java programmers to access the database, and the interfaces of each developer are not exactly the same. After years of JDBC with Oracle, I've accumulated a lot of skills

1. Start case without loading database You can start a case without loading the database, typically before the database is created:STARTUP Nomount2. Start the case and mount the database The user can start the case and mount the database without

1. Create a stored procedure Create or Replace procedure test (var_name_1 in type,var_name_2 out type) as--Declaring variables (variable name variable type)Begin--The execution body of the stored procedureEnd test;Print out the time information

Had seen someone converted, at that time just marvel, then passed, did not write down, until the use of the time, began to look everywhere, looking for to find no traces of the heart is also unhappy ah. Today unintentionally, see connect by use, see

The idea of the Oracle paging stored procedure is the same as in SQL Server, but I have made some changes here, and the Oracle paging stored procedure looks a little different because of the differences in Oracle's syntax and rules. Laughed, laughed!

The Creates a function in Oracle that was intended to return a index table without success. Think of the text can also transfer information, suddenly came to the inspiration, the return value set text format. The return value type is set to CLOB,

Because the project needs to be under Linux for php5.3 Oracle client compiler, briefly introduce the steps and the detour. 1. Download the Oracle client package, which contains related files such as OCI, Occi and Jdbc-oci. 1.1 Download file

Objective Whether in the development of B/s or C/s, JavaScript is basically not used to operate the database. And I have a idea that I need to add a lot of news class information to the database, so I want to get the information from each RSS site

When the data in the table is deleted, it does not actually delete the data, but instead it makes a deletion mark that can be recovered as long as it is not overwritten. The experimental process is as follows: Sys@orcl>create table Bbed_test (x

On the itpub, I saw someone raise the question. In SQL Server or some other database, DDL statements can be rolled back, so why can't oracle rollback DDL statements? To illustrate this issue, first you need to explain what a DDL statement is. A DDL

Oracle connections are common for processes with Local=no parameters or with Local=yes. Local=no: Not a local connection, that is, a network connection. It is connected to the server through listener. The client's application listens to the server

Two days ago, I saw a post on the itpub, referring to how to use the fastest way to SYSDBA log in to the database. The method that is given is to sqlplus the direct carriage return and then enter/as SYSDBA when prompting the user name:

This article discusses how to use ado.net to access Oracle stored procedures (called SQL programming Blocks) and functions (a programming block that returns a single value). You can connect to an Oracle database using the following managed data

Oracle's Exp/imp are two tools that many users often use. They are often used to do database logical backup, database reorganization and data transfer, and so on. The data is unloaded from exp to the file system first, resulting in one. DMP files,

Query initialization parameters A lot of ways, such as show PARAMETER, or query V$parameter, here a brief summary. This article briefly introduces a variety of query initialization parameters methods. There are a number of ways to initialize the

Think twice about asking me today: Rman backs up the meaning of%a in format formats. In fact, Oracle's documentation has this statement: %a Specifies the activation ID of the database. But the description is not clear. In fact, junsansi means

Exception:The exception is a feature that is provided by the programming language to enhance the robustness and fault tolerance of the program.Exceptions are divided into:System exceptionsCustom exceptionsSystem exceptions are divided