Writing high-performing database code is one of the key ingredients to maintain and improve customer satisfaction. In this course, Writing Executable Statements, you’ll learn to apply the guidelines and recommendations offered by Oracle in structuring your PL/SQL program and writing maintainable code. First, you’ll explore the lexical units that make up a PL/SQL program. Next, you’ll discover the operator precedence in building expressions using built-in functions. Finally, you’ll learn how to write nested blocks and understand the scope and visibility of the variables. When you’re finished with this course, you’ll have the skills and knowledge of writing an effective PL/SQL program needed to create a fast performing backend.
Author Name: Saravanan Dhandapani
Author Description:
I have worked in IT design, development, and architecture for over a decade for some of the top fortune 100 companies. I have designed and architected enterprise applications and developed scalable and portable software. I am a Google Certified Professional Architect. Critical areas where I have worked are architecture and design using Java, ESB, Tomcat, ReactJS, JavaScript, Linux, Oracle, SVN, GIT, and so on, and cloud technologies, including AWS and GCP.