I’ve been looking for an excuse to muck about with scala for a while now. So I thought i’d do a post similar to those I’ve done the past for .NET, python, perl and R. Best practices for Java were included in my book Oracle Performance Survival Guide (but I’d be more than happy to post them if anyone asks).
One of the great things about scala is that it runs in the JVM, so we can use the Oracle JDBC drivers to access Oracle. These drivers are very mature and support all the best programming practices.
Best practices for programming Oracle in any language require at least the following:
Use bind variables appropriately.
Ensure you are performing array fetch when retrieving more than one row
Ensure that you use array insert when doing bulk inserts
Thanks