Tag: database

On Tuesday, May 7 the Bryxx launch event took place. In the beautiful setting of the Flandria boat, and in the presence of a large number of customers, we revealed the services of this new venture. As a joint venture between the iAdvise and Contribute infrastructure teams, Bryxx will specifically focus on the middleware field. […]

Because it’s there that you’ll find out how your organisation can benefit from Oracle’s new technologies! Are mobility and the cloud opportunities for your organization or threats to its security? Can applications, hardware and software really work together? Is Oracle 12c a sensible investment? Is drowning in (big) data unavoidable? How can business intelligence become an integral part of IT structure? If at least one of these questions rings a […]

There’s a new Oracle source available:  All Things Oracle. The aim of All Things Oracle is to provide a gateway to the wealth of information and material available for Oracle developers and DBAs. The site brings articles and other resources of Oracle experts. Just to name a few: Alex Nuijten -Database Development – Oracle Ace […]

On friday my quiz was on the PL/SQL Challenge. Topic: “Guidelines for Designing Triggers: Avoid Non-Transactional Logic in DML Triggers” Yes, about “statement restart”🙂 My idea about the quiz was “making developers aware of the Oracle behaviour”. And I hope a lot of PL/SQL developers learned from it. It wasn’t easy to come up with […]

Today I explained the “statement restart” problem to a colleague. Every database developer has to know about this one… Short: Any statement can be restarted! This means that when you do one update statement, oracle CAN restart the statement. Every code in a trigger can be executed multiple times, so watch out with package variables […]