From the course: Oracle Database 19c: PL/SQL

Oracle Database PL/SQL: Why use it with Oracle Database 19c? - Oracle Database Tutorial

From the course: Oracle Database 19c: PL/SQL

Start my 1-month free trial

Oracle Database PL/SQL: Why use it with Oracle Database 19c?

- [Bob] Oracle database 19c is a new milestone over its long history of innovation. It can be an autonomous database for both data warehouse and OLTP workloads, which makes the DBAs job easier than before. It lets them work more on the design, development and implementation side of Oracle database. Instead of constantly trying to tune or debug issues when the database is slow. Most importantly, the programming language built in to Oracle database 19c is called PL/SQL and you can't easily use key database features without it. By covering some of the basics of Oracle database 19c PL/SQL from calling other functions and procedures, looping, conditional programming and exception handling. You'll be able to get data out of your database tables with select and get data in with DML. With Oracle's PL/SQL language, you'll be able to easily enforce business rules and use procedural constructs, instead of declarative statements in Oracle SQL. Hi, I'm Bob Bryla and I'm an Oracle database administrator by day and also by night. I see Oracle databases with custom PL/SQL procedures as part of the backbone to help businesses be successful. Let's start my LinkedIn learning course on Oracle database, 19c PL/SQL.

Contents