Craig Shallahamer: 1. Set based processing will likely be much faster than row based processing. Our experiment of processing 100K rows showed row based processing was 3700 times slower than set based...

Steven Feuerstein gives us a great and simple example of how to use bind variables to avoid concatenation of variable values into dynamic SQL strings and, at the same time, improve performance by order...

Elke Phelps: You can use the Oracle Data Masking Pack with Oracle Enterprise Manager today to scramble sensitive data in cloned environments. Due to data dependencies, scrambling E-Business Suite data...

ALTER TABLE sys.dual ADD (dummy2 VARCHAR2(1)); Tom Kyte: You never, never never never, as in never ever – touch any of the SYS tables – not to insert into them, not to delete from them,...

By Roddy Rodstein: The Infrastructure as a Service (IaaS) chapters review how to plan, design, deploy and support Oracle VM for x86 with Oracle Linux, Solaris, and Windows virtual machines Managed by...

What Type of Business Conference Cliché Are You? Here is how you can learn #Oracle ADF online #Oracle 11gR2 RAC Quick Reference All you need to know (and more) about #Oracle Database 11g Release 2...

Dimitrios Kalogirou offers good advice: Write self descriptive code ! Your code should be read like sentences. Avoid smart shortcuts and tricks because they break the reading… I use code comments...

Hallmarks of a Great Developer The Best of Linux Software How to be a Programmer: A Short, Comprehensive, and Personal Summary Getting started with Oracle SQL Developer in less than 5 minutes The...

Oracle EBS File Comparison Report Now Available How to read your (Microsoft Exchange) email using Oracle SQL and PL/SQL PL/SQL Warning Messages in Oracle SQL Developer 10 classic mistakes that plague...

Continue reading... © Eddie Awad's Blog, 2012. | Permalink | Add a comment | Topic: Oracle | Tags: quiz By: [author-name] This article was syndicated via RSS from: http://feedproxy.google.com/~r/EddieAwadsFeed/~3/paiSuDP8r5s/