Oracle

1. Installing ODACDetermine the ODAC version of the download according to your operating system x86,x64Http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.htmlDuring installation, be careful to configure the location and

Oracle 10g Advanced Replication instances (multi-agent replication)Objective:Configured three times, two is one way. The last time is finally two-way. Also a little bit of success in the joy. Joy? Joy does not. It's such a simple thing that I feel

About Oracle "ORA-12514 TNS Listener does not currently recognize request service in connection descriptor" errorReason:The listener server name is not specified in Listener.ora.Here's how to solve the idea:Try 1, start the database by restarting

First, the purpose:Profiles in an Oracle system can be used to limit the database resources that a user can use, creating a profile using the Create Profiles command, It is used to implement restricted use of database resources, and if the

Installing 32-bit and 64-bit Oracle clients first in many Oracle installation introductions, there are references to setting 2 points, one, E1, and environment variables. nls_lang=simplified Chinese_china.

the size of the Oracle query table, the usage of the table space, the default table spaceThe size of the Oracle query table, the usage of the table space, the default table space--View a table takes up disk space (table name capitalization)Select

Today, I saw someone write a custom aggregation function, so mindedly want to understand, on the Internet to find information. Introduction to custom aggregate function custom aggregation function interfacesOracle provides a number of pre-defined

When I recently used oracle9i, I encountered problems with database backup and recovery, which are often related to the use of exp and IMP commands. For the problems encountered, a simple summary.The background of the problem is the need to import

Declarex number; Beginx:=9;> --Cycle point x:=x-1;dbms_output. Put_Line (X); IF X>0thengoto Repeat_loop; --When the value of X is less than 9 o'clock, goto repeat_loopend if; end;/For loop usage in OracleDeclarex number; --declaring variable

In Oracle, the Utl_file package provides a number of functions and procedures for manipulating text files, learning about his basic operations 1. Create a directory and give the user authorization to copy the Code code as follows:--Creating

1. Create/* Step 1th: Create Tablespace */Create Tablespace XybiDataFile ' E:\oracle\oradata\zzxe\xybi_d01 ' size 100M;/* Step 2nd: Create a temporary tablespace */Create temporary tablespace xybi_tempTempfile ' E:\oracle\oradata\zzxe\xybi_t01 '

Oracle cursors Use the full solutionThis document contains almost every aspect of Oracle cursor use, and all passes the test--Cursor cursor_name is select_statement--For loop cursors--(1) Defining cursors--(2) Defining a cursor variable--(3) using

This article has been redirected from an excessive number of Oracle Dblink connections (Ora-02020)Today, when dealing with data synchronization issues, it is necessary to synchronize data from several other DB servers to a single target repository,

Using JDBC to connect to the database, fly is divided into three steps:The first step: Download a JDBC driver, then throw the jar package into the project and add to build path;Step two: Go to the local Oracle folder to find "TNSNames." ORA "file,

In fact, this is not a new topic. But before in many projects, always encountered in the Oracle database access, there will be a variety of problems, the most basic is to install a variety of clients on the client, the version is different, there

The recent database query encountered a problem, the database is a number Type field, in the Java type corresponding to have an integer and BigDecimal will appear;The test found that when the database is SQL Server and DB2, the integer type is taken

I wrote a data synchronization method, data synchronization between two databases, you can call the stored procedures, add jobs to implement timed synchronization data.CREATE OR REPLACE PROCEDURE Data_sync_common (tableName in varchar2) is V_sql

--CREATE TABLE SpaceCreatetablespace imarkdatafile'E:\oracle\product\10.2.0\oradata\orcl\imark.dbf'size 500Mautoextend on Next100M MaxSize Unlimited logging extent management local AutoallocatesegmentSpaceManagement auto;--Create userCreate

1: Common functionsTo_date () function to convert a string to a date formatSelect To_date (' 2015-09-12 ', ' YYYY-MM-DD ') from dual; --The subsequent date format to match the previous conversionTo_number () function to convert a string to a number

-----------Books: Oracle query optimization overrides-----------1th "c## #oracle" is the user name of the login database, and the 2nd "Oraclechange" is the name of the database to log in as the password "Oraclechange" for the login database./*Create