What you'll learn

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.