(Andrejus Baranovskis) As probably everyone of you have heard – this week was released Oracle JDeveloper 11g Technical Preview. I have looked through 11g release and should say, that if Oracle JDeveloper 10.1.3 was smart enough tool, then Oracle JDeveloper 11g is simply smart :). There are a lot of

(Jonathan Lewis) Some time ago, I was asked to take a quick look at an application that had to handle a lot of LOBs. The LOB-specific part of the application was actually quite simple – contracts were stored as LOBs – but only for occasional visual reference; all the “structured” information from th

(Tarry Singh) Our last article was about the Extended RAC–a way to spread out our RAC nodes across the city. Whether your RAC is in the building or outside, a smart and prudent DBA always monitors RAC.

(Lucas Jellema) In JDeveloper 11g, as another example of declarative productivity, we can add a List of Values definition to an attribute in a ViewObject, indicating that typically that attribute whenever included in for example and ADF Faces page should be implemented with a List Binding in a Selec

(Ilya Petrenko) This query finds how many numbers, upper-lower characters, and symbols.

(Steve Callan) One of the relatively newer features in Oracle concerns the moving of rows. Why would a row move and who or what controls that movement? Furthermore, by “move,” what exactly does move mean? Does a row move to another table, or is row movement constrained to the row’s container (i.e.,

(Bob Watkins) A spate of recent news stories has highlighted the importance of protecting database backups. Backup tapes stolen from banks, brokerage houses, retail stores, and even the IRS have exposed data from millions of customers (source: Chronology of Data Breaches).

(Syed Jaffar Hussain) As part of upgrading all our production databases from 8i & 9i to 10g, last Friday, early morning, we had successfully upgraded our core banking business critical database from 9i to 10gR2.

(Lucas Jellema) There are many things that can help make this world a better place. A pure SQL-based Gantt-chart is not one of them. However, that is exactly what this article will present to you. So you might as well skip it.

(Andrejus Baranovskis) This post is based on my previous post – Invoking Create method programmatically. I have decided to extend it and to show how Edit form for newly created data should be opened. While Create functionality is reused, in Edit form Master-Detail relationship is implemented. Master