Oracle

When you configure ADG or use the HA for cluster management applications of Oracle (such as OGG), we may want to use a different network to avoid the impact of ADG transmission logs on the primary production network.Starting with 11.2, we can use

Oracle Wallet use and maintenance Starting with ORACLE10GR2, the use of Oracle wallet to reach any user without a password login database (not operating system authentication method) is very useful for scripting database operations, especially for

Today, someone is looking for me in Taobao, need Oracle Database recovery support Remote login to see the database mount when the report Ora-600[kccpb_sanity_check_2] Error C:\Documents and Settings\administrator>sqlplus/as

A package is an attribute of Oracle Pl/sql, which is like a container or a namespace that combines a variety of logically related types, constants, variables, exceptions, and subroutines. Provides a good organizational unit when writing large,

Each Oracle user has a name and password and has some tables, views, and other resources created by it. An Oracle role is a set of permissions (privilege) (or the type of access each user needs depending on their status and conditions). The user can

An example of using the LAG analysis function to set the repeating field to null is as follows: The data for the test table test_xx are as follows: To achieve the following output results: The test SQL statement is The code is as

Let's start with some of the scripts we use to back up and restore Oracle databases directly using commands Oracle Data Backup: Step 1 Back up the user data. 1. Connect the Linux terminal using the database administrator account under Linux

Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix

Comparison of several types of timestamp TIMESTAMP The timestamp type, unlike date, is that date cannot be accurate to milliseconds, and timestamp can be accurate to milliseconds, with a millisecond of 0-9 digits and a default of 6 bits.

single-record functions in SQL 1.ASCII Returns the decimal number corresponding to the specified character; Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual; A A ZERO space --------- --------- --------- ------

This example describes Oracle's pl/sql. Share to everyone for your reference, specific as follows: First, what is Pl/sql? Pl/sql (procedural language/sql) is an extension of Oracle's standard SQL language. Pl/sql not only allows you to embed SQL

Order by unstable sortAsk a question: is Oracle a stable sort algorithm when ordering by? found that after sorting with a type, do a paging query, the first page of data and the second page of the data is repeated suspected to be order by, two

Whether it is the implementation of the paging query code in the DRP or interview questions to see the investigation of the paging query, give me a hint: Paging query is important. It must be considered when the volume of data is large. Never took

In a recent security audit, one of the requirements is: File integrity detection The corresponding database is the installed program files, configuration files (excluding data files, log files) That is, the need for regular database software

Implicit cursors: You can only return one row of results at a time (no definition, default auto-build) Span style= "Font-family:courier new, Courier; FONT-SIZE:16PX ">  explicit cursor: Requires a developer to define in advance, you can loop

Check extraction process modein the Ggsci environment, execute a statement similar to the following to see the status of a particular process. Ggsci>Info Where, is the process name.Example: the Epubadm process extraction mode shown isIntegrated

Problem: An error occurs when a dependency is introduced.1. First we are going to download an Oracle driver jar package, Ojdbc6.jar (I have Oracle installed here, so in the Oracle installation directory F:\app\zyh\product\11.1.0\db_1\jdbc\lib The

Download Source Code Providing an example form for creating hierarchical trees in Oracle Forms to control data Block records. The This form whenever the user selects any node in the tree menu then corresponding the record is displayed at right side.

Nls_lang is an environment variable that defines language, geography, and character set properties. For non-English character sets, the Nls_lang setting is very important.NLS: ' National Language Support (NLS) ' When we set up a nls we were actually

Disaster handling methods for Oracle data files being mistakenly deletedsteps:when the Oracle data file is mistakenly deleted after the processing Method!! 1. Close the database:sqlplus "/as sysdba";Sqlplus>shutdown abort;2. Loading the