Oracle

The concept of cursors: A cursor is a memory workspace of SQL that is defined by the system or user as a variable. The role of a cursor is to temporarily store blocks of data that are extracted from the database. In some cases, the data needs to be

Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most

This forum article mainly introduces the Oracle database backup strategy related concepts and the use of attention, detailed content please refer to the following First, understand the importance of backup It can be said that from the day the

oracle| Function | conversion | String Oracle Common numerical functions, conversion functions, string functions introduced. numeric function: Absolute value of ABS (m) m MoD (M,n) m is the remainder after the n is removed Power (M,n) m's

The most recent Oracle 11g RAC installation ran into a INS-30507 error, that is, when the grid was installed to create the ASM Disk Group, no candidate disks were found, and Google did not find any clues to the N-Multiple installation instructions.

A Some advantages of RMAN backup 1. RMAN detects and reports corrupted blocks of data. 2. RMAN can connect to the backup database without having to put the table space into hot backup mode. Additional build redo logs are generated during hot

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/05/D7/wKiom1mtGVDSusvRAAYGcg97wFw550.png-wh_500x0-wm_ 3-wmp_4-s_2418458466.png "title=" the DBA Training "alt=" Wkiom1mtgvdsusvraaygcg97wfw550.png-wh_50 "/>There is no doubt that today's

In the last essay, we set up two tips for departments and sub-departments, and we associate departments with sub-departments. So, in this essay, we focus on the use of the built-in double hints for the transfer of parameters.Before we do this, let's

The problem to the machine environment:Oracle 11gR2 64bitNavicat for Oracle 11.0.10According to the practices of some of the great gods on the internet and some of the personal speculations, the following are summarized:The problem occurs because

In this Document Goal Solution 1. Master List showing sample code for APIs in Product Data Hub 2. FAQs

Oracle database system is one of the most popular client/server (client/server) or B/s architectures in the United States Oracle Corporation (Oracle) provides a distributed database-centric set of software products. Oracle 11g R2 is the second

Variable introduction when writing a PL/SQL program, you can define variables and constants, including: 1 in a PL/SQL program, scalar type (scalar) 2), composite type (composite)--for manipulating a single record 3), reference type (reference)--

In Oracle RAC, the health of the RAC can be detected from multiple levels, with several different mechanisms, i.e. the heartbeat mechanism and a certain voting algorithm can be used to isolate the fault. If a node fails to detect, the faulty node

Oracle Data Integrator 12c installation (ODI installation)Enterprise Edition installation steps (including standalone installation steps)Download Oracle Data Integrator 12CR2 (12.2.1.0.0) address on official websiteFor example, when installing ODI,

1 ORACLE mid-week related knowledge description 1.1 Date formatting functions To_char (X [,FORMAT]) : Press X toFORMATThe format is converted into a string. X is a date,FORMATis a format string that specifies the format in which X is

In Oracle 11GR2, the login audit information for SYS users is logged by default in the Audit_file_dest directory, but the operation content is not audited.Enable auditing of SYS user action behaviorSql> alter system set AUDIT_SYS_OPERATIONS=TRUE

EXP-00008: encountered Oracle error 904 ORA-00904: "maxsize": Invalid identifier Cause: the Oracle version is different. Run C:/> exp PLX/PLX @ orcl file = C:/PLX. dmp tables = (S, SC, c) Result Error Export: Release 11.1.0.6.0-production on Sunday

Oracle PL/SQL practiceBasic InformationAuthor: (English) bilington (A.) and so on, Lu Tao [Translator's introduction]Press: People's post and telecommunications PressISBN: 9787115294852Mounting time:Published on: February 1, November 2012Start:

Oracle 10 Gb manual database creation method generally, the tool that is more convenient to create a database is to use the dbca tool that comes with oracle, which is really very convenient. However, production databases in some industries (such as

Import/export is the oldest two surviving ORACLE command line tools. In fact, I never think Exp/Imp is a good backup method, the correct statement is that Exp/Imp can only be a good dump tool, especially in small database dump, tablespace migration,