Oracle

Here is a test, in which the library creating the database link is XJ (WINDOWS 2003 Oracle 10g 10.2.0.1), the linked library is Dmdb (LINUX AS5 Oracle 10g 10.2.0.1 RAC)Part I: How to create a DblinkThere are two ways to create Dblink:1. Configure

The data in Oracle is backed up.Description:Usage Prerequisites:The Oracle client needs to be configured.Function:Back up the Oracle database.DescriptionNewly backed up database in the backup directory, the last backup is stored in the Old_backup

The Oracle garbled problem is generally caused by inconsistent Oracle character set settings and operating system character set settings, which have to mention two operating system environment variables, LANG and Nls_langLang is a set of languages,

Internal optimization issues for Oracle databasesThe internal optimization of Oracle database is a complex issue, and when you think of the internal understanding of Oracle, Oracle has removed some of the old features and added some new features.

Functions of the PL/SQL Foundation/* function: You can have a PL/SQL subroutine that returns a worthy name and must have a return value keyword:function return*/-- function 1Create or Replace function Helloworldreturn varchar2--specifies the return

Recently participated in 4, 5 interviews, summed up the competition in the Oracle development post most frequently asked what questions:1. What is the difference between delete and truncate?1) Truncate is a DDL statement, and delete is a DML

1. Select FOR update2. Foreign key does not create index(1) There are frequent deletions on the main table(2) There are frequent modification operations on the primary key.(3) The main table and the associated query from the table are often present

In an Oracle database, the data paging feature is an essential operation,There are three types of Oracle database paging query statements:--1. According to rowID to divideSELECT * from NMB where rowID in (Select Rid from (Select RowNum Rn,rid from (

If you accidentally overwrite the previous stored procedure, it's time to flash back, and the longer it is, the less likely it is to flash back. The principle is very simple, the definition of the stored procedure is a data dictionary, modify the

Two days to solve the configuration of configuring the Oracle listener to use SQL operations St_geometry, search a large web, the results really found only methods available, below this method I personally in the summary.ArcSDE10.1 Configuring the

Lab environment: Operating System: Oracle Linux Server release 5.7 64 bit Database Version: Oracle Database 10g Release 10.2.0.4.0-64bit Production Case study: To test and verify the validity of the backup, you need to restore the backup set of

PL/SQL basic getting started code block PL/SQL:A programming Language combined with a Structured Language (Structured Query Language) is an extension of SQL and supports multiple data types, such as large objects and Collection types, you can use

Introduction: In MyBatis, when you want to insert data in Oracle, the primary key value is returned, instead of the number of inserted data... Environment: MyBatis 3.2, Oracle, Spring 3.2 SQL Snippet in XML Configuration: SELECT

Create table mytest (name varchar (20), password varchar (30 ));Create or replace procedure sp_pro2 isBeginInsert into mytest values ('fc ', '123 ');End;View error informationShow errorHow to call this process:1. exec process name (parameter ,..)2.

Triggers and packages based on PL/SQL Package /* Package: encapsulate objects such as stored procedures, functions, variables, cursors, and exceptions. Voice and body composition Advantages: 1. modularization; 2. Easier application design; 3.

Basic PL/SQL Functions /* Function: You can have PL/SQL subprograms that are named, and must have returned values. Keyword: function return */ -- Function 1 Create or replace function helloworldreturn varchar2 -- specifies the return type. The

CASE Environment: Operating System: Oracle Linux Server release 5.7 64 bit Database Version: Oracle Database 10g Release 10.2.0.4.0-64bit Production Case study:On the server where the instance is just installed, when you use dbca to create a new

Stored procedures based on PL/SQL Stored Procedure: A process is a subroutine used to complete a specific task (a collection of code) /* Advantages of subprograms: 1. modular, decomposing programs into logic modules; 2. reusability, which can be

Common scenarios: When the Oracle database is backed up from the server and then restored to the local machine, the character encoding of the database is inconsistent, you can run the following command to modify the character encoding of the local

Test environment: Install Oracle Enterprise Linux 5.8 64-bit Virtual Machine in VMware Workstation v9.0.2 Install software: jdk-7u40-linux-x64.rpm?apache-tomcat-7.0.53.tar.gz Installation instructions: Download jdk-7u40-linux-x64.rpmand