May 2000
Intermediate to advanced
594 pages
11h 32m
English
Content preview from Oracle PL/SQL Programming: A Developer's Workbook
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 21. DBMS_SQL Built-in Package
DBMS_SQL is probably the most flexible and powerful (and potentially dangerous!) of the built-in packages. By giving you the ability to construct and execute SQL and PL/SQL statements and commands on the fly, DBMS_SQL makes a wide range of applications possible. For example, you can use the package to write your own web-based version of SQL*Plus by allowing users to enter a variety of DML and DDL commands into a browser, or you can build a self-modifying program that adds or drops PL/SQL components as they are needed. This chapter tests your understanding of this remarkably useful built-in package.
Figure 21-1 shows the flow of DBMS-SQL execution.
Beginner
21-1. | What does “dynamic SQL” mean? |
21-2. | What does “dynamic PL/SQL” mean? |
21-3. | What are the four different methods of dynamic SQL? |
21-4. | What is a “placeholder” in a dynamic SQL string? |
21-5. | What DBMS_SQL program can you use to open a dynamic cursor? |
21-6. | What DBMS_SQL program can you use to close a dynamic cursor? |
21-7. | What DBMS_SQL program can you use to parse a dynamic SQL string? |
21-8. | What DBMS_SQL programs can you use to execute a dynamic cursor? |
21-9. | What DBMS_SQL programs can you use to fetch rows from a dynamic cursor? |
21-10. | What DBMS_SQL programs can you use to extract values from columns and variables in a dynamic cursor?  Figure 21-1. DBMS_SQL execution |
21-11. | How can you include values stored in variables ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.