Is PL/SQL dying?

In this Office Hours episode, we covered
The confusion about moving tables with a LOB
Which NUMBER data type is the best to use
How DataPump objects from just a single tablespace
How to control resources between pluggable databases
Is PL/SQL dying?
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
Other social media channels here: linktr.ee/connor
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

[@krakajak67]

PL/SQL is a robust language, with a strong lineage (ADA, etc.). It’s one of my favourite languages to work in, because SQL itself is embedded within.

[@sabyasachimitra5719]

To ask "is PL/SQL dying?" is equivalent to asking "Is Oracle dying?" PL/SQL will remain alive as long Oracle is alive. It may not be the next "cutting edge" programming language which GenZ likes to learn but when it comes to solving a problem inside Oracle, it's PL/SQL.

[@Shortvidz7]

True

[@iShaymus]

That’s potentially correct and incorrect at the same time. The thing that will likely kill oracle db will be the lack of pl sql developers. Already in our market people are getting off oracle not because of the tech, but because they can’t get staff who know how to work with it. PL/SQL developers are becoming the new COBOL developers in our market. We’re a small market so we tend to hit critical mass sooner than other markets but usually in a Crystal ball predictive way.

[@ryanoconnor_guitar]

Timestamps: 06:33 Introduction 12:06 PBS resource limit not working 22:07 Move a LOB online 30:01 water break with Poland oracle user group conference glass that safely made it back home in a briefcase :) 30:51 Number Data Type 43:07 Is PL/SQL dying? 52:52 Second water break with our lucky Poland glass that didn't break during travel :D 53:03 Datapump single table space 57:11 Outro

[@pavanmadamset]

Thank You very much Sir

[@ddgflorida]

PL/SQL Dying ? I hope not. It's solidly embedded in Oracle products so I'd say no. The language could use an update though. All databases need a high level procedural language.

[@QueryTuner]

Connor, related to the documentation - pushing either the thumbs-up or thumbs-down button, there pops up a message window where you can give some feedback. Greetings from Good Old Germany.

[@dunarelb]

Just look at the viewers number for any Oracle product vs. anything opensource. You have to be a corporate employee to even start thinking about it. Oracle cloud is a bit better though.

[@tajsmart1]

Thanks, Timestamps would help.

[@raafnaah887]

Hell no. It’s not. It’s the master layer around our database to implement core business/data logic

[@asrytube]

Using PL/SQL last 8 years. And I expect to use for long enough. Fingerscrossed.

[@12345abcd_qwerty]

Getting pl/sql developers is so difficult. Building a solution around pl/sql makes me nervous because I will not be able to support it. New developers are more attracted towards python and other languages.

[@abdulraheemalawadi9824]

Cool , thank you

[@raymondallo9947]

Not as long as I live.

[@dennisk648]

PLSQL is terrible to express complex business logic and maintain it. You need some strong arguments to invest into it.

[@oracledevs]

We'll need to agree to disagree :-) but in particular, it is often that case that we need just some simple data manipulation and PL/SQL is ideal for that, because you are not moving the data, which is typically the most costly part of the exercise.