Oracle

1. Create a link to the database operation, SQL Server can use Ado.net, operations Oracle can use OLE DB or System.Data.OracleClient (need to add a reference to use) The advantage of this scheme is simple, each write their own database operation

  3, ROUND function ROUND (number, num_digits) rounds numbers to only num_digits decimal places. 4, Lpad, Rpad function Lpad () function: The Lpad function fills the left string with some specific characters whose syntax is as follows: Lpad

Triggers can be created inside Oracle DBA Studio Tools CREATE TRIGGER name Create trigger-creates a new trigger     Syntax CREATE TRIGGER name {before |   After} {event [OR ...] }   on table for each {ROW | STATEMENT} EXECUTE PROCEDURE func

1. Create an external Table directory Create directory Extdir as ' E:appextdir '; 2. Define External Tables CREATE TABLE Ext_test ( RT date, Rtype char (1) ) Organization External ( Type Oracle_loader Default directory Extdir Access

 /** * Separate Java program connects to the Oracle database * Author:javaalpha * date:2012-12-3 12:02:44 */ Import java.sql. *; public class Test { public static void Main (string[] args) { String driver = "Oracle.jdbc.driver.OracleDriver" ;

Oracle is one of the most used databases in the world, and the Active Server Web page (ASP) is a powerful server-side scripting language that is widely used to create dynamic Web pages. Many ASP developers have been considering the possibility of

asp.net|object|oracle| Data | database 1. Add a reference to the Web application project first: Interop.oracleinprocserver 2, the Web.config configuration: " ...... 3, Global.asax Create the Oraclesession object, the code is as follows: Using System;

datagrid|oracle| data tired, finally found how to bind the data table to the Dategrid method. But this time to make an empirical error, the beginning is to Google, looking for a long time did not find, and later found in the CSDN community. Oh,

Oracle| Program | introduction | Clients are mainly to do three pieces of work: packaging files, write the registry, register environment variables Description: My Oracle version is 9, test pass on Advanced Server, you can create a database

You may be running an Oracle 10g Release 2 database server, but supporting some applications may have been written very early. Data tables created prior to Oracle 8i typically have a long data type to store large text. With the introduction of the

1. InstallationOracle10g R2 Software2. To play Oracle 10g the latest patch, I'm playing a patch to upgrade to 10.2.0.23. Run pre-upgrade information Tool. It is used to analyze some of the things you need to do before you upgrade to 10g, such as

I. Statistical information of the table The statistics for a table describe the details of the table, including typical dimensions such as number of records (Num_rows), number of blocks (blocks), average row length (Avg_row_len), and so on. These

Http://d.hatena.ne.jp/yohei-a/20100515/1273954199dtraceでoracle databaseのサーバー?プロセスをトレースしてみたOracle, Mac2010-03-22-Future のいつか/hyoshiokの Day102th back カーネル Reading book will occupies line ってきて, Dtraceを make ってみようと think ってもう2ケ month near くすぎた.やっと makes

From the original source Oracle's Numer type corresponds to the c,c# data typehas recently been working on an Oracle database-related program.The correspondence between the number type of Oracle and the C language, the C # language type, has been

READ UNCOMMITTED (the lowest level of isolation transaction, only guaranteed not to read physically corrupted data)Read Committed (the default level of the database engine)REPEATABLE READSerializable (the highest level of isolation transactions,

1, the creation of the primary keyMethod One: Declare the field PRIMARY KEY constraint directly in the SQL statementCREATE TABLE table_name (ID type[length] constraint pk_name primary key,name tyoe[length],age type[length],class_id);Method two:

"Fault description"ASM Disk group dropped, ASM instance cannot mount. ASM Disk Group has 4 500G disks, database and ASM software 10.2.0.1, the Oracle database is in urgent need of recovery."Failure Analysis"Analyze the disks that make up the ASM

How to change the Oracle character set to avoid garbled charactersTurn the notes of a great God.The most commonly used Oracle character set ZHS16GBK (GBK 16-bit Simplified Chinese) in the country supports traditional Chinese and stores a Chinese

Oracle XmlType starts with Oracle 9i to support a new data type that stores and manages XML data and provides a number of functions for saving, retrieving, and manipulating XML documents and managing nodes. XmlType is a system-defined type, so it

To connect to a database step:1. Registration driver (only once)2. Establishing a connection (Connection)3. Create a statement that executes SQL (Statement)4. Execute the statement5. Processing execution Results (RESULTSET)6. Releasing