December 22, 2022 Use a Single Connection in Oracle- Developing Successful Oracle Applications-4 So, they don’t know that the following table in particular exists: SQL> create table user_pw The prior USER_PW table looks like a pretty important…
December 22, 2022 Use a Single Connection in Oracle- Developing Successful Oracle Applications-3 Executing SQL statements without bind variables is very much like compiling a subroutine before each method call. Imagine shipping Java source code to your…
September 22, 2022 Layered Programming- Developing Successful Oracle Applications Once you understand that each database will implement features in a different way, another example of defensive programming to allow for portability is to…
July 22, 2022 Server Parameter Files (SPFILEs)- Files SPFILEs represent a fundamental change in the way Oracle accesses and maintains parameter settings for the instance. An SPFILE eliminates the two serious issues…
April 22, 2022 Read Consistency and Nonblocking Reads- Developing Successful Oracle Applications Let’s look at the implications of multiversioning: read-consistent queries and nonblocking reads. If you are not familiar with multiversioning, what you see in the…
April 22, 2022 Multiversioning- Developing Successful Oracle Applications This is a topic very closely related to concurrency control as it forms the foundation for Oracle’s concurrency control mechanism. Oracle operates a multiversion,…
January 22, 2022 Flashback- Developing Successful Oracle Applications In the past, Oracle always decided the point in time at which our queries would be consistent. That is, Oracle made it such that…
December 22, 2021 Database Independence?- Developing Successful Oracle Applications By now, you might be able to see where I’m going in this section. I have made references to other databases and how features…
July 22, 2021 Make Sure You Can Adapt- Developing Successful Oracle Applications The goal is to fully use the facilities available to you, but ensure you can change the implementation on a case-by-case basis. As an…
June 22, 2021 Implementing Locking- Developing Successful Oracle Applications The database uses locks to ensure that, at most, one transaction is modifying a given piece of data at any given time. Basically, locks…
