Showing posts from May, 2026
To set up Java and Apache Tomcat on your Windows PC for local development, follow these steps. Step 1 — Install Java (JDK) Tomcat requires Java. Recommended Version Use: Java 17 (LTS) Recommended vendors: Oracle JDK Eclipse Temurin (OpenJDK) I recomme…
Generic Dynamic Mail PL/SQL Procedure with Dynamic Query, Body and CSV Attachment CREATE OR REPLACE PROCEDURE FMS_ADMIN.SEND_DYNAMIC_MAIL_WITH_ATTACHMENT ( P_TO_MAIL IN VARCHAR2, P_FROM_MAIL IN VARCHAR2, P_SUBJECT IN VAR…
Removing non-printable / ASCII characters oracle 🔹 1. Your Current Approach (Valid but Heavy) REGEXP_REPLACE(column, '[^[:print:]]', '') ✔ Removes all non-printable characters ❌ Expensive for large datasets (regex on every column) 🔹…
