(Shraddha Pandya) Oracle supports the pushing of predicates into a given view.

(Andrejus Baranovskis) It seems Oracle Spatial functionality can be used successfully with TopLink Essentials JPA also. I have reviewed in detail Doug Clarke (Principal Product Manager for Oracle TopLink) post about how it looks in theory – Oracle Spatial using TopLink Essentials JPA. And, have impl

(Anil Passi) In this article, I would like to explain different possibilities of Forms Personalizations. Surely before explaining what can be done, first we will touch base upon what exactly it is.

(Brian Peasland) I have a 2-terabyte database. I don’t have a standby database and I don’t have a cold backup of the database. I have last night’s hot backup. One user unexpectedly dropped a table. How can I restore the table with minimal time? (R)

(William Robertson) Need to calculate the number of minutes between two dates? Yes, the dull way is to subtract one from the other and multiply by 1440. But why do that, when you can simply convert each date into Julian format by converting it into a string and then back to a date, and converting th

(Erika Morphy) Oracle’s new integration architecture is not a substitute or even an interim step leading to Fusion’s introduction. Rather, it is a process-centric tool, allowing customers to extend the platform to their legacy applications and otherwise manage processes that rely on several differen

(David A. Kelly) Making the pieces of your enterprise infrastructure work together wasn’t always easy. Proprietary and best-of-breed systems were cobbled together with proprietary, best-of-breed, and custom in-house middleware solutions. The result of this assembly was often a messy patchwork of app

(Lawrence Linnemeyer and Bradley Brown) Validations, computations, and processes greatly increase the functionality of an HTML DB application. In this three-part series (of which this is the first part), you’ll learn about the different types and where to use them.

(Tarry Singh) Implementing RAC, or any clustered solution, requires planning. Many mission critical applications tend to be very demanding and are often load balanced both at front end (application servers) and backend (database servers). Let’s try to break it up into several components such as netw

(Jeroen van Wilgenburg) It seems innocent, a few lines of code used twice in the same application. But before you know know it those lines appear 272 times in your application! You guessed it right and you’re probably wondering how could that happen. I’ll try to explain what happened and how to prev