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

I. Data Control statement (DML) section 1.INSERT (Insert the statement into the data sheet) INSERT INTO 表名(字段名1, 字段名2, ……) VALUES ( 值1, 值2, ……); INSERT INTO 表名(字段名1, 字段名2, ……) SELECT 字段名1, 字段名2, …… FROM 另外的表名; field values for string types must

  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

Oracle | Stored Procedure | example | implementation /Oracle execute in sample stored procedure /Reference $ Gconn = ocilogon ("test", "test "); /* Ocidefinebypos example thies@digicol.de (980219 )*/ /Discrate and necode is out parameter, the

oracle| Tips 1. Find Useless index: 　　 DML performance is low, one of the most serious reasons is the existence of useless indexes. All SQL inserts, updates, and deletions become slower when they need to modify a large number of indexes when each

oracle| Data | database | questions Oracle's data block has a fixed format and structure, divided into three layers: Cache layer, Transaction layer, and data layer. Do a consistency check when reading and writing a block of data: –block

oracle| Control | data | detailed SQL language is divided into four categories: Data Query Language DQL, Data manipulation language DML, data definition language DDL, Data Control Language DCL. It is used to define the structure of the data, such as

Oracle| Experience Oracle's system is too large, for beginners, it is inevitable that some will not be able to feel, what all want to learn, the results of what are not good, so the learning experience to share, I want to let just get started people

oracle| Tips Oracle Experience skill set 1. Delete a table space DROP tablespace tablespacename [including CONTENTS [and Datafiles]] 2. Delete User DROP USER user_name CASCADE 3. Considerations for deleting a table When you delete all the data in a

oracle| Encryption | data | problems Oracle 9i2 Features: 1, the return value is the custom object type function. For example, the Sdo_geometry data type. 2, can use Java or C language to write stored procedures. ÷ Oracle Spatial Advanced

Oracle transferred from Mark Rittman's blog Http://www.rittman.net/archives/001130.html is Oracle A Legacy Technology? One of the nice things about working and the Oracle RDBMS, compared to say working with technologies such as as/400, COBO L or

oracle| notes On-Machine Environment: Windows2000 +oracle 9i Teaching Situation: All English (because my English is limited, not all understand) Course Arrangement: A total of 20 classes, 2 hours per class or so, attach a number of quizzes, one

oracle| Control | data | Details setting up and modifying the user Create USERS statement creates a user. When a user connects to an Oracle database, it must be validated. There are three types of authentication in Oracle: Database external Global

oracle| Performance | optimization 31. Force Index Invalidation If two or more indexes have the same level, you can force the Oracle optimizer to use one of them (through which the number of records retrieved is low). Example: SELECT

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,

With the popularization of computers and the development of the network, the database is no longer just the topic that the programmer is proprietary. and Oracle database is by virtue of its outstanding performance, easy to operate and flexible

On the AIX platform, Oracle software that is tar from the RAC environment is directly extracted to the new machine and the target environment is stand-alone, and the RAC option needs to be turned off. RAC off 1. Login as the Oracle software owner

Make a practical use of the previous article. Encountered in the work of a large table (50 million data), at the beginning of the forgotten to create an automatic partition, resulting in the use of the very inconvenient, the speed of the query is

The recent use of Oracle Export Import data, read some other people's articles on the Internet, summarized as follows:There are two ways to export and export the Oracle: first, import with exp imp, second, export import using oracel data pump EXPDP

Bbed is the abbreviation for Block Browser/editor and is an internal tool of Oracle that does not publish documentation and support. Bbed is released with the software, but we need a simple relink to use.　　 While there are many risks to the