rollback

When a large number of database inserts, modify, delete and other operations, if you want to implement transactions, you can use the following code. Such as: On Error Resume Next strsql1= "INSERT into a (num) VALUES (1)" Strsql2= "INSERT into a

Oracle Oracle DBA Day-to-day management Modified: 2000/8/23 Author: Thomas B. cox,with Christine Choi Objective: This document has very detailed information on one or more Oracle databases per day, monthly, The results of the yearly running status

MySQL provides us with a lot of table types to choose from, there are MyISAM, ISAM, HEAP, BerkeleyDB, Innodb,merge table types, radish cabbage is not false, but the real choice of what kind of table type or to see business needs ah, Each type of

ADO Caching a Query Last month, we had a quick look at how to do Select, insert, and update in ADODB. If you are a novice on ADODB, I suggest that you read the last month's article first. ADOdb has a lot more advanced features, and this month,

Data | database Java Database Basic Operations 1. Java database Operation Basic process 2, a few commonly used important skills: • Scrollable, updated recordsets • Batch Update • Transaction Processing Java database Operation basic process: Get

I wasn't going to start the computer today. Too sleepy, want to sleep, but a buddy text messages are sent over, to ask a question, so or open the computer, did not think is a very representative problem, incidentally also involved a few days ago I

Transaction processing In many large, critical applications, computers perform a number of tasks every second. More often than not, the tasks themselves are combined to accomplish a business requirement, called a transaction. What happens if you can

Acid property is the cornerstone of database theory, which defines the four properties that a theoretically reliable database must possess: atomicity, consistency, isolation, and durability. Although these four properties are important, isolation is

In the process of using Oracle, we often encounter some Oracle errors, for beginners, these errors may be a little fuzzy, and may not know how to deal with these errors, I used to appear in the more frequent error code one by one to make analysis,

ajax| page | Flip Button | bookmark This article provides an open source JavaScript library that provides the ability to add bookmarks and fallback buttons to AJAX applications. Ajax "How to handle Bookmarks and rollback buttons" illustrates a

PowerBuilder (PB) is a strong development tool based on client/server architecture launched by PowerSoft Company (has been acquired by Sybase), and has been well received by developers since its inception. DataWindow is a patented technology in PB

Server The configuration options for SQL Server servers are those that people understand less and are often misused. When a technical support person asks you to adjust an option in some way, and another technical support person asks you to adjust

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

What's the difference between delete and truncate? The way to delete data in a table is Delete,truncate, They all delete the data in the table, not the table structure, delete the data from the entire table or delete the data from one or N of the

The database is starting up. If you detect a data file that is missing or corrupted the rollback segment tablespace, and the database is running, do not drop it. In many cases, the database is open rather than closed to solve the problem. Two

Database updates are usually caused by events that occur in the objective world. In order to ensure the consistency of the database content, a set of operations of the database should be carried out as a whole, either complete successfully or all

If Oracle unfortunately encounters undo corruption in operation, the best approach is full recovery, but if there is no backup, you can take an unconventional approach (taking advantage of the hidden parameters of Oracle) and if undo contains

We want to do not only write SQL, but also to do a good performance of the SQL, the following for the author to learn, extract, and summarized part of the information to share with you!(1) Select the most efficient table name order (valid only in

oracle| Data | database | speed | Statistics are often used in large database systems, but for large data systems, users often feel slow to perform complex query statistics and can not meet application requirements, which requires us to design the

SQL execution efficiency has always been a concern, how should it be improved? What better way, below share with you under the more good suggestions, interested friends can refer to, I hope to help you Copy code code as follows:If you have multiple