From the course: Oracle Database 19c: PL/SQL
Join today to access over 25,300 courses taught by industry experts.
Running SQL statements: Static - Oracle Database Tutorial
From the course: Oracle Database 19c: PL/SQL
Running SQL statements: Static
- One of the huge benefits of Oracle PL/SQL is not only that it's a complete third generation programming language, but also integrates seamlessly with Oracle SQL in two different ways, static SQL and dynamic SQL. Static SQL statements fall into three categories, select statements, DML statements, and transaction control statements, which work the same way they do outside of PL/SQL. You already know how to run individual SQL statements in SQLcl or SQL Developer, but how do you run them in PL/SQL? You don't want to have to rewrite the statements just so they work in a different environment. PL/SQL accomplishes that goal. There are three basic categories of SQL statements you can run in PL/SQL. Select statements, DML statements, and transaction control statements. With only one exception, you run the standalone SQL statement as is in PL/SQL. If anything, running SQL statements in PL/SQL is enhanced to give you even finer…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.