Obsessed with Oracle PL/SQL

Developers and DBAs: can't we all just get along? Sure we can! We just have to break out of the old routine of Developer: Hey, DBA, add twelve indexes to make my code run faster! DBA: Hey, Developer, tune your code to make it run faster! That is, finger-pointing. Instead, we need to work together, and developers I am not the least big reluctant to say: It's up to us, not the DBAs, to take the first steps. So here are tips on what you, the developer, can do to foster a strong, collaborative and highly productive relationship with your DBA: 1. Ask your DBA for advice.  "I want to make my code run faster. What do you think I should do?" There's no better to improve a relationship than to show some humility and express interest in the opinions - and knowledge - of others. 2. Do the right thing.  Learn about the performance-related features of PL/SQL (and SQL) and apply them . Here are some links to help get started: PL/SQL Optimization and ...

Chris Saxon , a Developer Advocate at Oracle, has put together a 12 week "bootcamp" introduction to SQL . Each week consists of a short video, plus 3 quizzes. You probably won't need more than 30 minutes to complete them. Every fourth week, Chris will be on a live webcast to answer questions. While there is a start date for each new class, there is no end date. This means that you if you missed the beginning week or two (or seven!), you can still register for the class and take the earlier classes. To do this, visit the Oracle Dev Gym (for which you will need an Oracle account). Then go to the Classes page in one of two ways, shown below with the blue arrows. Click on Databases for Developers, then click on the Register button. You can then pick from any of the weeks in the Course Outline that have already been started, and work your way through them. We hope you enjoy, and get lots out of, the Databases for Developers course! And while you are at the...

I gave a webinar on April 6, 2017 for the Taste of Kscope17 series for ODTUG (odtug.com) on Change Impact Analysis with PL/Scope. Here are the slides from SlideShare. I will add a link to the video when it is available. Impact Analysis with PL/Scope from Steven Feuerstein After my presentation, this question came up: if you set the optimization level to 3 (inlining of subprogram code), will that change the PL/Scope data gathered? Interesting question. Suppose your function body contains an assignment to variable x. Just that one place. But the function is called in ten places. Will PL/Scope find ten assignments to x or just one? Just one , as you can see in this  LiveSQL script . The identifier information is gathered before optimization. Which makes perfect sense. Post-optimized code is no longer PL/SQL code. Here's the procedure I tested this one: CREATE OR REPLACE PROCEDURE PLSCOPE_DEMO IS PRAGMA INLINE (f1, 'YES'); FUNCTION f1 (p NUMBER) ...

Copyright @2017 CodeNewsWire "News coders can use", dateline 1 April 2017 Wikileaks dumped its latest batch of revelations on the world on April 1, 2017, this time focusing on the world of software programming. From dishing out the dirt on the origins of the Internet (think: Area 51) to emails candidly deriding JSON as nothing more than the latest attempt (XML being the last one) to avoid carefully designing your database, this trove of previously secret secrets is sure to keep Silicon Valley gossiping for months. But buried deep within the 2.5 trillion byte download is evidence of a conspiracy so vast, so unbelievable, so extraordinary, that it is hard, well, to believe. But if it came from Wikileaks it must be true. And that conspiracy was built around - and is maintained around - this incredible bit: All modern programming languages, from Java to JavaScript, Scala to Go, are actually all implemented in the Oracle PL/SQL language. Oh, and Linux, too. You are probab...