#PLSQL

SQL Assertions are faster than #plsql triggers because context switching is avoided. Of course, declarative assertions are also a huge advantage over custom coded procedural triggers 👍

As we promised during #PLSQL #AskTOM Office Hours with @sfonplsql we now share the Application with you. Find App and Readme here:

Are you interested in the origins of #PLSQL? If so, hear about it from the original team members in my post, A (Not So) Brief But (Very) Accurate History of PL/SQL -

Don't miss this free PL/SQL #MOOC - Enroll today: #PLSQL

👉 Free #Oracle Course: Learn to write simple PL/SQL blocks with SQL commands #PLSQL

Hitting the "fast=true" switch on APEX_DATA_PARSER #orclapex #performance #plsql

Trivadis #PLSQL & #SQL Coding Guidelines v4.3 released. Including two new guidelines for the @OracleDatabase 23c. HTML: PDF: Release Info:

"That binary could also be executed by the host or in a VM (written in PL/SQL). That VM could run any machine language we make up as it’s a VM." - #oracleace #plsql #scripting #language

10 "secret" Oracle DB features you might not know #sql #plsql #aced

PL/SQL can be used to write a compiler for an existing language such as C, BASIC or even PL/SQL itself. - - #oracleace #plsql #scripting #language

Latest project: "Quick PL/SQL", a tool (inspired by Quick SQL) to quickly generate #oracle #plsql code based on simple markup. #orclapex @mikehichwa1 @sfonplsql Blog post:

New Post! The power you now get in PL/SQL 21c loops is batsh*t crazy :-) #plsql #oracle #21c

Tip: Need to call a PL/SQL program, and need help with the parameter list? In @oraclesqlcl you can the INFO command to get a PL/SQL call to invoke your code! Works in our @OracleSQLDev GUIs as well! #oracle #plsql #code #developer #database

🚀 Learn PL/SQL Fundamentals: Composite datatypes and explicit cursors #Oracle #PLSQL Free Course:

#PLSQL programmers: when others then raise; end; I'm collecting pros and cons. Any opinions?

It's a wrap. Biggest UC AI release ever. Small and big improvements. I will do more learning material about it in the next weeks. BTW: free + open source. #orclAPEX #AI #PLSQL #oracle

PL/SQL: The Good Parts #oracle #plsql

📝 I wrote a blog post on how to use a Maps like in-memory data store in #oracle #plsql. They are called Associative Arrays and are super handy! #orclapex

I banged out two posts about why PL/SQL should be on your radar the last couple of days, and common comments about vendor lock in came back. So lets put that to bed as well! #database #developers #plsql #sql

Are you a #PLSQL #developer? Here's all you need to know about the way@OracleDatabase manages datetime values