How transactions guard your database, PL-SQL Programming

How Transactions Guard Your Database

The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL statements as a unit so that all the changes brought about by the statements are either committed (made permanent) or rolled back (undone) at similar time. If your program fails in the center of a transaction, then the database is automatically restored to its previous state.

The first SQL statements in your program begin a transaction. Whenever a transaction ends, the next SQL statement automatically begins the other transaction. And hence, every SQL statement is part of the transaction. The distributed transaction involves at least one SQL statement which updates the data at multiple nodes in a distributed database.

The COMMIT and ROLLBACK statements assures that all the database changes brought about by the SQL operations are either made permanent or undone at similar time. All the SQL statements executed as the last commit or rollback make up the present transaction. The SAVEPOINT statement names and marks the present point in the processing of a transaction.

Posted Date: 10/4/2012 4:51:02 AM | Location : United States







Related Discussions:- How transactions guard your database, Assignment Help, Ask Question on How transactions guard your database, Get Answer, Expert's Help, How transactions guard your database Discussions

Write discussion on How transactions guard your database
Your posts are moderated
Related Questions
Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

Perform the following queries on the Hospital1.DB using SQL Anywhere (START EARLY!). a. Which patients have purchased the drug "Tylenol"? List the names and addresses. Arrange the

1- You can check attribute names from each table in DBF11 by running for example:  desc dbf11.Member;  desc dbf11.Agent;  desc dbf11.Producer; Because some attribute names in

Functions The function is a subprogram which can take parameters and be invoked. Normally, you can use a function to calculate a value. The function has 2 sections: the specifi

ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check

Built-In Functions The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below: error r

FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t

I have a Pascal Source file that needs to be compiled into a Service. In addition, there are various functions (Pascal Procedures I guess) that need to be created to Read and Write