Oracle

Oracle stored procedure [reprinted] Http://blog.bossma.cn/archives/2008/01/80 1. Insert data:Insert several data entries into a table /* Create a table tb1 contains two fields: col1 and col2 */ Create Table tb1 (

OS statisticsJohn also needs to eliminate the possibility that the host system is a bottleneck when carefully checking the user's performance problems. Before using Oracle for 10 Gbit/s, he can use operating system (OS) tools such as SAR and vmstat

Oracle oo4o Recently, this project is VB.net and Oracle. Because of the customer's requirements, Oracle provides oo4o instead of traditional ODBC. The full name is Oracle Objects for OLE (oo4o ). According to Japanese data, this is the most

Exp parameter descriptionKeyword description (default) keyword description (default)--------------------------------------------------------------------------Userid username/password full export the entire file (N)Buffer data buffer size owner User

package com.huawei.oracle;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class OracleTest {public static void main(String[] args) throws

In the article "Install RHEL 5.2 record (1)", we will first learn how to install rhel5.2 to install oracle. After some exploration, we finally set up the RHEL environment, including the Chinese language environment (although this is not much help

By default, if Oracle is installed in windows, the corresponding service is registered and automatically started as the operating system starts. However, in Linux (Environment: rhel5.2), some configuration is required to implement this function. The

Sometimes we need to import some table data from the SQL Server database to the Oracle database. When the data is imported successfully, it is found that the query by field always prompts that the column does not exist. In this case, you need to

  Cursor XX (a, B, c...) is SQL statementBegin Open xx;LoopFetch XX into A, B, C...Spell stringExit when XX % notfound;End loop;Close xx;   Bytes --------------------------------------------------------------------------------------------------------

  Http://space.itpub.net/9399028/viewspace-687358    A usage for getting down from the Internet OracleSent Email Stored Procedure. You can directly call this stored procedure by sending an email. The parameter meanings are described. The Code is as

Document directory 2. Usage of case when in different positions in the statement 1. The case when expression has two forms: -- Simple case function case sex when '1' then' male 'when' 2' then' female 'else' other 'ends -- case search function

Technorati label: Oracle -- Create the directory dir_dump as a sys user and save the file to this directory.SQL> create directory dir_dump as '/data/cmssdb ';Directory created.-- Authorize the read and write permissions of the corresponding

Install Ubuntu 10.10on Windows 7. download and run wubi.exe to install the software on any disk. Install oracle in Ubuntu... Hard work! But it's okay! I found a lot of information and made a lot of detours. The summary is as follows: First,

Log Files, also known as redo log files, record user changes to the database and can be used for database recovery. In practical applications, log file images are generally used. If one of the log files is damaged, log files of other images can also

A control file is a binary file that is automatically created when a database is created. It is used to record the database name, creation time, tablespace name, data file, and log file location. The control file is very important to the database.

 -- 1. Learning jobs in PLSQL -- Learning job -- Create a table Create Table test_job (para_date date ); Commit; Insert into test_job values (sysdate ); Commit;   Select * From test_job; -- Establish the storage process Create or replace procedure

This article from: http://blog.csdn.net/caihaijiang/article/details/6083566   1. Download the instant client from the Oracle Website: Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html Select different Instant

EXP/IMP tool:With parameters: rows = y -- with data export and import; rows = n -- without data export, only the structure is transplanted. Example: Export the structure of only three tables:Exp user/pasword @ dbservername owner = user tables = (tb1,

Environment: Oracle 9.2.0.8, AIX 5.3ml5 64bit; Table A is a partitioned table that stores about records. The table's tablespace is not in assm mode; Scenario Description: Because the operations on the table are very frequent, the I/O waits

SQL wm_concat FunctionExpert Oracle tips by Burleson Consulting September 19,201 0 Question: I have a table test_test and I need to count the distinct mark columns and them display all matching values on one line: Name mark-------------ABC 10Def