Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using Dynamic SQL

Dynamic SQL is an advanced programming technique. Every application needs to anticipate, automate, and integrate input from the user in their SQL commands. This course will teach you how to face these challenges with the use of dynamic SQL.

Dynamic SQL is a very powerful and versatile programming technique provided by Oracle for its databases. Every growing application faces the need to anticipate the querying demands of the users. Re-using existing code can drastically reduce the time spent on development, review, and testing. Security concerns are always important and allowing direct SQL queries to the database may not always be the best idea. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using Dynamic SQL, you will learn how to address these issues. First, you will explore how to turn a regular query into a dynamic one and when there is the need for this conversion. Next, you’ll learn to bind types to dynamic queries, a very helpful way to pass around data from the users or from within the database. Finally, you’ll learn how to alternatively approach the dynamic SQL problem. When you’ve finished this course, you’ll have the skills and knowledge to approach dynamic SQL needed for your application and also you will be ready for taking the Using Dynamic SQL section in the 1Z0-149 exam.

• Course Overview 1min
• Getting Started with Dynamic SQL 13mins
• Dynamic SQL Additional Clauses 21mins
• DBMS_SQL Package 15mins