Browsing Tag
oracle
8 posts
Best Oracle Database Design Tools in 2025
When you’re looking for a database design tool, it’s not just for fun – you actually need one!…
How I Reduced My Oracle SQL Execution Time from 110s to 2s
🧩 The Problem Recently, I encountered a performance bottleneck while writing a SQL query: the execution time was…
How to Write a Token Price Oracle Smart Contract
Introduction In the rapidly evolving DeFi ecosystem, accurate and reliable token price data is fundamental for various applications…
Stored Procedure in PL/SQL
Stored Procedure A stored procedure in PL/SQL (Procedural Language/Structured Query Language) is a set of SQL statements that…
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
Introduction This article is based on real problems I had in a production environment in Oracle 11g. Oracle…
How to Setup Jenkins Locally With Oracle VirtualBox VM
Creating The Virtual Box VM Installing Jenkins on VM Opening the firewall Setting Up Port Forwarding Setting Up…
Streamlining Database Connectivity and Oracle Compatibility with EDB Postgres Advanced Server
Introduction: In today’s digital landscape, seamless database connectivity and compatibility are crucial for organizations. EDB Postgres Advanced Server…
Resources to learn pl/sql for free
watch entire playlist here : pl/sql tutorial : https://youtube.com/playlist?list=PLCWQNLd8T4_gxqzav19GJyrEjZBL4ytA2 ************************************* Oracle SQL Tutorial : https://yo… youtube.com