#PlSQL

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

LOGGER is a free PL/SQL framework that helps debug, track errors or calculate code timings. You can also use it in APEX or any other application that uses Oracle Database. Check out my latest blog post about it. #orclAPEX #plsql #oracledatabase

Practice your #SQL and #PLSQL skills at the Oracle Dev Gym @sfonplsql gives you the tour

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

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

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 👍

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

In Oracle EBS, always use bind variables in SQL queries whenever possible. ✅ Improves performance through cursor sharing ✅ Reduces hard parsing ✅ Helps prevent SQL injection #OracleEBS #SQL #PLSQL

Latest #plsql tutorial on How To Declare User-Define Exception using RAISE_APPLICATION_ERROR in Oracle...

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

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

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

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:

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

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

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

"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

"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

Monday's Tip for Oracle APEX: Did you ever want to get the data out of your APEX report? In the past, it was a bit complicated because you had to get the query and then run it but now it's easier than ever. Read this thread to know how 🧵 #orclAPEX #SQL #PLSQL 1/5