Oracle

The following article mainly describes the actual comparison between the Oracle database and DB2 and MySQL with the first 10 records. The following article mainly uses Oralce as an example to explain their differences, the following is a detailed

The following article describes how to access SYBASE-related data in an Oracle database and how to configure the transparent gateway for Sybase, I hope this will help you in your future studies. 1. Install Sybase client on the server where Oracle is

Oracle single-line string functions are one of the most important Oracle functions. The following describes the syntax of Oracle single-line string functions in detail. If you are interested in Oracle single-line string functions, take a

The Oracle query date operation can implement many dates we need. For example, we can implement the number of days in the month to which the Oracle query date belongs. Let's take a look at the implementation of this method. The number of days of

How can we optimize the memory usage of oracle? For the convenience of development, we want to reduce the memory occupied by oracle at ordinary times. The following describes how to reduce memory usage by adjusting oracle memory parameters. Solution:

We know that,Oracle DatabaseEach process in to complete a specific task or a group of tasks, each process will allocate internal memory PGA memory) to complete its tasks. Oracle instances mainly have three types of processes:Server processBackground

OracleThe decode function in the database is one of the common functions of Oracle PL/SQL. What is its purpose? Next we will introduce this process and how to use it.SAS macroTo implement the decode function in the Oracle database. First, let's

  1. Oracle tracking File There are three types of Oracle trace files: one is the background alarm log file, which records the activity of background processes during database startup, shutdown, and running, such as creating tablespaces, creating

  Where can I start learning about Oracle? Here, I will take you to the door of Oracle. One chapter a day, seven days of entry is not a dream.   1. PL/SQL PL/SQL is a procedural extension of Oracle in the standard SQL language that allows embedding

  Today, a database server login failed, report TNS-12541: TNS: no listener Check the listener status on the server   1. oracle @ linux-34: ~> Lsnrctl status 2. 3. LSNRCTL for Linux: Version 11.1.0.6.0-Production on 14-OCT-2011 09:12:37 4. 5.

1. Enhanced add column descriptionIn Oracle 11gR1, Oracle enhanced the add column. Instructions on the official website:Http://docs.oracle.com/cd/B28359_01/server.111/b28279/chapter1.htm#NEWFTCH1 1.1 Enhanced add column FunctionalityDefault valuesof

The OCR and Voting Disk backups in Oracle RAC are described in my blog: common maintenance tools and commands of Oracle RAC. Now I will explain it separately, because OCR and Voting Disk are too important for the RAC system. Oracle RAC commonly used

For PL/SQL connection, 64-bit Oracle has recently changed to 64-bit Win7, and oracle has also changed to 64-bit 11g. After the change, we found that the plsql cannot load the database at all. There are also various changes to version Shenma on the

ORA-00001: unique constraint violated solved the error of inserting data into the database today: www.2cto.com ORA-00001: unique constraint (IDX_CARTON_HEADER) violated. that is to say, when inserting data into CARTON_HEADER, there is a unique

Rename the column name and table name in oracle directly in pl/SQL and then in oem, however, you may not be able to change the lower-case table name to the upper-case table name. At this time, www.2cto.com can be changed using SQL statements. In

When rebuild index VS. rebuild index online create index and rebuild index are used, the No. 4 lock will be applied to the original table, and the No. 3 lock will be applied to obj $ to prevent DML operations on the original table. Create index

Powerful SQL: SQL Cookbook Reading Notes 1-sorting the mixed data of letters and numbers recently, I am reading a really good book on SQL Cookbook. Many solutions are very subtle, I really realized that SQL is powerful. Note: I use ORACLE 11g and

All about Oracle IMP/EXP import/export is the oldest two command line tools survived by ORACLE. 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

The SQL * Plus copy command is used to process mass data replication. For data replication at the database TABLE level, the most common method is CREATE TABLE AS (CTAS. In fact, the copy command under SQL * Plus can do the same job, and it is better,

Oracle HowTo: how to change the location of Oracle data files in Oracle Database in read-only mode. There are multiple ways to move the location of data files. I have introduced several methods before: Oracle HowTo: in non-archive mode, how does one