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!

Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

[krakajak]

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

[sabyasachimitra]

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.

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

[raafnaah]

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

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

[asryoutube]

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

[jacks]

Hello Oracle,
I want to learn development in oracle.
But i am an accountant.
Can anyone please guide?
Thanks