Oracle

Transferred from: Http://www.cnblogs.com/zhaoDotNet/archive/2010/09/17/1829509.html Author: zhaodotnet Thanks to zhaodotnet for sharing his experience.   Recently, I met the founder of hubbledotnet on the Internet. At his request, I wrote

1. Export the database test completely, and the username System Password Manager is exported to D: \ daochu. dmp. Exp system/manager @ test file = D: \ daochu. dmp full = y 2. Export the tables of system users and SYS users in the database

Method 1: the simplest method (database creation required) Backup:Directly copy the admin and oradata folders in the Oracle directory and the database under the ora92 directory to other storage for backup. Recovery:1. Create a database that is

Start --> Oracle InstallationProgramAccording to --> net configuration Assistant Select Listener Configuration --> next --> Add (generally, the server configuration may cause problems, so Add a new listener) --> Add a listener name (the name of the

Varchar2(Size)Variable-length string,Length required Char(Size)Fixed-length string,The default value of the unspecified length is 1. Number(P, S) Precision P value range: 1 ~ 38 Valid bit s value range:-84 ~ 127 S is a positive number, and the

Create or replace view ov_applicant of ob_applicant with object OID (applicantid) as select * from applicant; -- ov_applicant is equivalent to applicant. Insert into ov_applicant values g_ob_applicantinfo; -- Insert data in g_ob_applicantinfo

Left: Select E. last_name, E. department_id, D. department_name From Employees E Left     Join Administrative ments d On (E. department_id = D. department_id ); Equivalent Select E. last_name, E. department_id, D.

Format: (not in package) Create or replace function function_name (argu1 [mode1] datatype1, argu2 [mode2] datatype2,...) return datatype isResult varchar2 (50 );BeginReturn result; end; Call: VaR V1 varchar2 (100) Exec: V1: = function_name;

 1. Create a stored procedure Create Or Replace Procedure My_procedure Is -- The cursor is used here. Cursor Cur Is Select * From Users Where Length (name) > 10 ; Begin For User In Cur Loop Insert Into

[Application Scenario] many colleagues have asked me about pseudo columns. I mainly want to add some serial numbers = when exporting data. In fact, pseudo columns have many functions. Official reference: Oracle Database SQL Language Reference 1

Case: one field in an application table is the primary key. when inserting data into the table, the data is first put in the temporary table (without the primary key) and then inserted into the application table. At this time, if duplicate data

[Application Scenario] preparations before the system goes online. Generally, the Dump File Import method is often used for data migration. Because the data is imported by one user, a permission error (which can be ignored) is reported during the

I posted a post these two days to find a better way to randomly retrieve a record from the table. See: http://www.oracle.com.cn/viewthread.php? Tid = 20848   This article introduces the application of Oracle sample syntax. using sample is also

Export:Exp system/A @ orcl file = (F: \ faisdb01.dmp, F: \ faisdb02.dmp, F: \ faisdb03.dmp, F: \ faisdb04.dmp) filesize = 3000 m owner = fais When exported to multiple files, if the number of files to be written is insufficient, the files are

Oracle Database Synchronization The test is successful between two Oracle databases. The following is a summary: Requirements: There are two Oracle database servers A and B (A and B can be on the same Intranet or two independent machines on the

Because almost all operating systems support virtual memory, even if the memory we use is smaller than the physical memory, the OS cannot switch SGA to the virtual memory (SWAp ). Therefore, we can try to make the SGA lock in the physical memory not

As we all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the Oracle client? In fact, I always wanted to do this, because

Win7 The system interface is very beautiful, It is really good to use, but it also brings a lot of trouble to my learning. Especially this installation Oracle Others use XP The system is easy to install, but I cannot install it. To make it

Oracle As a data transformation in the original relevant database, the view is mainly used to view some data in the relevant table. You can set Oracle A view is a moving window through which you can see the data you are interested in. A

1. Create a table named Test 2. Add data to the test table Insert into test (student, course, score)Select 'zhang san', 'China', 78 from dual UnionSelect 'zhang san', 'mat', 87 from dual UnionSelect 'zhang san', 'English ', 82 from dual