#PLSQL

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

Tuning #PLSQL using dbms_hprof and flamegraphs is fun! While optimizing a merge operation I found a spike caused by a before row insert trigger that used a non cached sequence. Wouldn't have noticed this otherwise. #aced @OracleDevs @OracleDatabase #sql

Version 17.2 now supports conditional compilation syntax in your PL/SQL #parser #formatter #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

utPLSQL for SQL Developer 1.4.0 is now available. All known bugs are fixed. Updated code templates. Showing the reason for disabled tests. #utplsql #plsql #sqldev #oracledatabase

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

UC AI v26.5 adds new ways to use AI in your Oracle database: decisions with probabilities, and A2A support so other systems can call your agents. The APEX Chat plug-in now supports cards, tables, charts, and custom widgets. #orclAPEX #oracle #plsql

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

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

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 👍

What if legacy PL/SQL could become modern Python without losing the logic behind it? That’s the real challenge in database modernization. Read the deep dive : #PLSQL #Python #DatabaseModernization #AI #LegacyModernization #ACLDigital

Look what I got at #apexworld2023. A book, not about #orclapex, but about my favorite languages SQL and #plsql. By @alexnuijten @patch72

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

I am looking for a skilled PL/SQL Developer, especially with strong experience in MS SQL Server and related database technologies, for daily support of 2–3 hours. Experience : 8 yrs Please DM me if anyone is interested or has suitable references. #Hiring #SQLDeveloper #PLSQL #MSSQLServer #DatabaseDeveloper #SQLJobs #TechHiring #OraclePLSQL #ITJobs #Developers #HiringNow #DatabaseJobs #PartTimeJobs #RemoteSupport #SoftwareJobs #OpenToWork

The @Trivadis #PLSQL & #SQL Coding Guidelines Version 3.3 are now available as GitHub Pages and PDF. It's just a conversion from Word to Markdown. No new content in this version. But much better (re)usability. #OpenSource

A follow up to the post yesterday on why PLSQL rocks. I made the benchmark more realistic...which means that..um...er...well.... PLSQL rocks even more! 😀 #sql #database #plsql

Monday's Tip for Oracle APEX: Are you still using "execute immediate" or the dbms_sql package do run dynamic SQL statements? Not that these options are bad, but if you are building APEX applications, there is a better one #orclAPEX #SQL #PLSQL 1/5

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 -

Fresh post! Put aside the fear mongering about database resident code and focus on the evidence. And the evidence is clear - if you want faster, more scalable applications, just a little bit of PL/SQL might make all the difference. #database #sql #plsql

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