<g-emoji class=📝 This VSTO Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum, " />
github

📝 This VSTO Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum,

Excel-projects/Script-Help :memo: This VSTO Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum, Markup or Markdown Languages. The functionality within the...

it.toolbox it.toolbox

Overloading Procedures in PL/SQL

A FAQ that I get, well, frequently, is about overloading procedures. I think most people get how to overload but not when or why. Today I am going to explain a classic example of where overloading makes your life easier. More importantly, it makes the life of the code maintainer behind you easier. I am going to use the sample data on the HR schema for this entry. Specifically, the EMPLOYEES table. In real life, I have...

it.toolbox it.toolbox

Oracle 12c SQL: A CASE Better Than PL/SQL CASE

I adopted Tom Kyte's mantra as my own long ago: "You should do it in a single SQL statement if at all possible. If you cannot do it in a single SQL Statement, then do it in PL/SQL. If you cannot do it in PL/SQL, try a Java Stored Procedure. If you cannot do it in Java, do it in a C external procedure. If you cannot do it in a C external routine, you might want to seriously think about why it is you need to do it…"...