How Does Oracle Handle Read Consistency

Categories:

.NET (357)

C (330)

C++ (183)

CSS (84)

DBA (2)

HTML (4)

Java (574)

JavaScript (106)

JSP (66)

Oracle (114)

Perl (46)

Perl (1)

PHP (1)

RSS (51)

Software QA (13)

XHTML (173)

Other Resources:

Software QA Resources

Developer Resources

Windows Tutorials

File Extensions

Security Certificates

Regular Expression

Link Directories

Interview Q & A

Biotech Resources

Cell Phone Resources

Travel Resources

Frequently Asked Questions

FYIcenter Forum

Home > Oracle > Transaction

How Does Oracle Handle Read Consistency

Q

How Does Oracle Handle Read Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management

✍: FYIcenter.com

A

Oracle supports two options for you on how to maintain read consistency:

READ WRITE (the default option), also called statement-level read consistency.
READ ONLY, also called transaction-level read consistency.

2007-04-18, 5283👍, 0💬

Popular Posts:

Can one execute dyna...

Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL databas...

How To Process Query...

How To Process Query Result in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL You can run queries...

What are the differe...

What are the different accessibility levels defined in .NET ? Following are the five levels of acces...

How To Display a Pas...

How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Qu...

How To Dump the Cont...

How To Dump the Contents of a Directory into an Array? - PHP Script Tips - Working with Directoris a...