Simple play icon Course

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

by Alexandru Huiban

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.

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.

About the author

Alex has over 12 years of software development experience. His main area of expertise is database development, pl/sql programming and exposing data with microservices. He sometimes gets lost in endless tinkering on small projects with the use of systems on a chip, mainly Raspberry pi.

Ready to upskill? Get started