Oracle

1. Open PL/SQL developer If PL/SQL developer is installed on the machine, open the PL/SQL developer interface. Enter the user name, password, and host name.ProgramThe configurations in Web. config are exactly the same. Click OK. Find the

Oracle uses on Delete cascade and on Delete set null to create a foreign key This section describes how to use the default Oracle creation method when creating foreign key constraints. When you delete referenced data, the data cannot be deleted,

Common levels of RAID are 0, 1, 3, and 5. The combination is usually 0 + + 0. Their respective features are described as follows:Raid0: Multiple physical disks are made up of a large Logical Disk with the total capacity of each disk. RW has the best

Oracle rownum Analysis For the rownum problem in Oracle, many documents do not support>, >=, =, between... and. The preceding symbols can only be used (,> =, =, .. and will prompt SQL syntax errors, but often cannot find a record, and it seems to

In Oracle, we can export data from the remote database server together with the object definition to a local DMP file, or import the DMP file from the local to a distant database server. This feature allows you to build several identical databases

Today I want to query all the table names in the Oracle database or all the tables in a user. I haven't thought about it for a long time. I still found the answer online. Select table_name from all_tables; // AllSelect table_name from

During SQL migration to Oracle, the table name and field name are capitalized, because the default table name and field name in Oracle are both uppercase, although double quotation marks can be used for operations, for example, select * from

If you have installed Linux according to the preceding instructions and all kernel parameters use the default values, you only need to log on as the root user and run the following command. Cat>/etc/sysctl. conf Kernel. Shmall = 2097152 Kernel.

Oracle finds and removes the deadlock Process 1. Find the deadlock Process Select /* + Rule */V $ lock. Sid,Decode (V $ lock.Type,'Mr ', 'Media recovery ','Redo thread', 'redo thread ','Non', 'user name ','Tx ', 'Transaction ','Tm', 'dml ','Ul ',

Modify the character set of Oracle 10 GB Modify the database character set to zhs16gbk.View server character setsSQL> select * from V $ nls_parameters;Modify:$ Sqlplus/nologSQL> Conn/As sysdbaIf the database server has been started, run shutdown

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up ORACLE data. The exp command can export data from the remote database server to the local DMP file, and the IMP command can import the DMP file from the local to

The kernel. shmmni parameter controls the total number of shared memory segments.The kernel. Shmall parameter controls the number of pages in the shared memory and is the total amount of shared memory that can be used by all users.Shmall =

Author: eygle | English version [indicate the source and author information and this statement in hyperlink form during reprinting] Link: http://www.eygle.com/archives/2011/12/oracle_linux_rm_rf.html A mistaken deletion case mentioned a few days ago:

Recently, the ETL project involved data import from the SQL Server database to the Oracle database. Many articles on the Internet use ORACLE transparent gateways, but since it is not free, I decided to use generic connectivity first. Most of the

Create or replace procedure p_web_memberinfor(P_memberid in varchar2,Member_resultset in out pkg_return_resultset.resultset, -- return result setMoney_resultset in out pkg_return_resultset.resultset, -- return result setPoint_resultset in out

Code transferred from http://brianyuzhao.iteye.com/blog/379823   Temporal Database is a time-based database. It not only processes the current database, but also processes the past and the future. A temporal database is a database with built-in time

I have installed Oracle10g on the server many times and thought it was absolutely easy. But who knows that an error occurred while creating a database: "due to the following error, enterprise Manager Configuration failed-An error occurred while

Numeric functions: Absolute Value of ABS (m) mMoD (m, n) m remainder after N DivisionPower (m, n) M's n powerRound (M [, N]) the value of M rounded to N digits after the decimal point (N defaults to 0)Trunc (M [, N]) m truncates the value of N

Oracle Study Notes: A bit of understanding about backup, restoration, and recovery (go @) Http://www.cnblogs.com/jinzhenshui/archive/2009/03/10/1407666.html   Oracle provides a wide range of Flexible backup, restoration, and recovery management

After successfully connecting to the database, check the listener status: LSNRCTL status Status ready status, which must be switched from non-archive to archive. The operation is as follows: 1. Shut down the database shutdown immediate and shut