#PLSQL

"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

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 👍

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

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

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

"Why would we want to add a scripting language to an application written in PL/SQL? There are a number of possible reasons." - #oracleace #plsql #scripting #language

📝 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

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

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

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

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

The Best #Oracle #PLSQL #programming Guide @plsql @Fr4ncis @yarishj @OraclePLSQL

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

New #PLSQL page on @oracleotn. Bookmark this great resource

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

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

My layman's guide to the use of EXCEPTION WHEN OTHERS THEN NULL #orcldb #plsql

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

Version 17.2 now supports conditional compilation syntax in your PL/SQL #parser #formatter #plsql

How to start debugging PL/SQL #Oracle #PLSQL #IDE