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…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…

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…

Set is a card game which is fun to play while exercising your mind. In this session you will learn about the SET game, as well as how you can leverage SQL to solve it really quickly. Learn advanced features of SQL, such as Subquery Factoring and ANSI join syntax while we're cheating in the…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…

During this presentation, a case study is unfolded to reveal the true cause of a slow performing query. Did the database just "have a bad day"? Was the evil DBA to blame? The PL/SQL developer who didn't get enough coffee? Or was it the application sending the "wrong" query in the first place? In this…

Set is a card game which is fun to play while exercising your mind. In this session you will learn about the SET game, as well as how you can leverage SQL to solve it really quickly. Learn advanced features of SQL, such as Subquery Factoring and ANSI join syntax while we're cheating in the…

Set is a card game which is fun to play while exercising your mind. In this session you will learn about the SET game, as well as how you can leverage SQL to solve it really quickly. Learn advanced features of SQL, such as Subquery Factoring and ANSI join syntax while we're cheating in the…