Oracle

Recently, winform was used as a small tool to connect to the Oracle database. There was no problem during development and it was able to connect to the database normally. Later, it was found that the database could not be connected, and the

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Create   Or   Replace   Procedure Send_mail (Pemail In Varchar2 ,PPW In Varchar2 ,PID In Varchar2 ) Is

There are four functions that support regular expressions in Oracle: 1. regexp_like: similar to like 2. regexp_instr: similar to instr 3, regexp_substr: similar to substr 4. regexp_replace: similar to replace functions, regexp_replace is

What is the difference between a temporary table and a formal table?What is the role of a temporary table?How can I create a temporary table?     Temporary tables are generally stored in temporary tablespaces.There are two types:

Original article 《Compatibility Matrix for Export & Import between different Oracle versionsFrom Oracle Metalink.When you deploy a new environment, importing, exporting, and transforming the Oracle database often takes a lot of time. If you

I always thought that the following statement (Execution 1) is an implicit cursor, which is not much slower than the explicit definition cursor (execution 2. For the sake of convenience and simplicity, I usually use the method of executing one to

■ Modify the initialization parameter control_files SQL> alter system set control_files ='/Export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control01.ctl ','/Export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control02.ctl

View the PID of all Oracle processes: # Ps-Ef | grep ora [Oracle @ dB ~] $ PS-Ef | grep oraRoot 23544 23514 0 00:00:00 pts/3 Su-OracleOracle 23545 23544 0 00:00:00 pts/3-BashOracle 23589 1 0? 00:00:02/dbsoftware/APP/Oracle/product/10.2.0/db_1/bin/

How to update different data before two tables? There must be different data conditions for multiple fields in multiple data entries. The following is an example: 1. Create a table Create TableTb1 (ID varchar2 (10 ), XM varchar2 (10 )

The exp export tool compresses data backup in the database into a binary system file, which can be migrated between different operating systems.The IMP import tool imports binary system files generated by exp into the database. 1. Export tool exp1.

I recently learned about Oracle databases and encountered some minor problems during the installation process. Although it was a minor problem, it made me spend a lot of energy trying to sum up and finally solved the problem, the mood is

Select B. table_name primary key table name, B. column_name primary key column name, A. table_name foreign key table name, A. column_name foreign key column name From ( Select A. constraint_name, B. table_name, B. column_name, A.

1 length () Measure the length of a character string. Length of the statistic data type for the char type The length of the data in the statistical field for varchar2 2 substr () Intercepted string For example, select substr ('aaaaa', 1,

Centos for Linux6.3OS VMware Workstation9.0.0Build-812388Oracle Installation File Path: G: \ Program Files \ Red Hat Enterprise Linux4\ Exchange data \ oracle-XE-10.2.0.1-1.0. I386.rpm 1 down load RPM from following location HTTP://Www.oracle.com/

In fact, the main problem of connecting to the database in Java development is not how to writeCode, But find the driver package. Because there are too many JDBC driver packages and many names, some of them still need to be installed on the client

Note: historical moments : Oh, my God, I don't know how to do it. I just did something about it. But it's definitely not the practice we know now. It's not an error that the installation is complete !!!!! Trying to figure out what you have done ...

Basic concepts: 1. Protection Mode: maximum protection, maximum performance, and maximum availability. The default value is the maximum performance. 2. physical and logical backup machines: 3. Online, archived, and standby redo logs 4. Log

  Name Ordinal Value Isdefault Audit_trail 1 DB 2 OS 3 None 4 True 5 False 6

Sometimes, when inserting a database, we may insert duplicate data, but do not want Modify existingProgram, We can use triggers to avoid modifying programs and solve problems directly in the database. Test procedure: 1. First, create a test

This is because more and more people have asked me this question recently. I want to write down my ideas. 1. How fast is it?Many people like shortcuts, so they often ask for shortcuts, but I often tell you that there are no shortcuts, or there are