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-mcdonald.com
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.

[@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

[@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.

[@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.

[@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.

[@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.

[@raafnaah887]

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

[@tajsmart1]

Thanks, Timestamps would help.

[@asrytube]

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

[@abdulraheemalawadi9824]

Cool , thank you

[@raymondallo9947]

Not as long as I live.