A humorous but serious look at Oracle's DATE, TIMESTAMP and INTERVAL types. In particular, focusing on the common misuse, alternate best practices and techniques for generating date ranges, filling in missing dates within existing data, manipulating timezones and Daylight Saving Time and exposing some quirks of manipulating the data types including illegal-yet-valid dates and indexing.…

A humorous but serious look at Oracle's DATE, TIMESTAMP and INTERVAL types. In particular, focusing on the common misuse, alternate best practices and techniques for generating date ranges, filling in missing dates within existing data, manipulating timezones and Daylight Saving Time and exposing some quirks of manipulating the data types including illegal-yet-valid dates and indexing.…

(Presented at Oracle Open World 11) "Throw more hardware at the project to keep up the speed" is a phrase heard all too often among IT professionals. Sometimes, additional hardware doesn't solve performance problems. When dealing with computer systems, XML documents are an effective method to communicate real time information between two or more computers.…

(Presented at Oracle Open World 11) "Throw more hardware at the project to keep up the speed" is a phrase heard all too often among IT professionals. Sometimes, additional hardware doesn't solve performance problems. When dealing with computer systems, XML documents are an effective method to communicate real time information between two or more computers.…

You want to engage the mobile market, but what's the best approach? A native application in the iTunes store, or a mobile version of your web site? With the latest ADF Mobile tools, you get the best of both worlds, because you can make native applications with nothing more than standard HTML5, CSS, and JavaScript!

This talk will provide tips for using SQL against an Oracle Database. It will discuss how to exploit a selection of lesser known features and also how to avoid traps and pitfalls. Examples of redundant and undocumented functions, such as OVERLAPS, REVERSE and the range of SYS_OP functions will be covered and some of the…

This paper re-introduces Perl as a language of choice for many solutions for DBA's and developers. Discover what makes Perl so successful and why it is so versatile. Perl can automate all those manual daily tasks and is truly platform independent so that your scripts can now run on Linux, Unix and Windows. Perl may…

You want to engage the mobile market, but what's the best approach? A native application in the iTunes store, or a mobile version of your web site? With the latest ADF Mobile tools, you get the best of both worlds, because you can make native applications with nothing more than standard HTML5, CSS, and JavaScript!

You want to engage the mobile market, but what's the best approach? A native application in the iTunes store, or a mobile version of your web site? With the latest ADF Mobile tools, you get the best of both worlds, because you can make native applications with nothing more than standard HTML5, CSS, and JavaScript!

Session Abstract: This presentation emphasizes on the role of DBA's in effectively analyzing Application load test. Database load testing and analysis not only helps DBA's in reducing production outage but can also detect performance degradation. This also helps in identifying existing bottlenecks which can result in further tuning of database to make it scalable .The…