Feed
Discussions

Oracle Database

Oracle Database

#oracle-database

93 followers·101 articles

Oracle Database

#oracle-database·93 followers·101 articles

Oracle Database

Changelog

New steps component and improved accessibility on Hashnode's blog and docs product.

Nov 05, 2024·

new

Trending Articles

Revolutionizing Decentralized Finance on TON: The Tech Behind Seamless Liquidity and Cross-Chain Swaps.

Patience Uyire·46 reads

Life2App: Redefining Engagement in the New Economy.

Patience Uyire·46 reads

Reimagining Mobile Wallets: The Future of Finance in a Decentralized Web3 World.

Patience Uyire·46 reads

Top commenters this week

Mayank Arora

Edward D. Cornett

Edward D. Cornett

Clarence

Melisa Parker

Charlie Simmon

Writing Challenges

#2Articles1Week Challenge

Become better at technical writing; accept Hashnode's writing challenge for four weeks.

#2Articles1Week Challenge

#WomenWhoTech

Share your story, achievements, or experiences as a woman, non-binary folk in tech or as a #WomenWhoTech ally!

#WomenWhoTech

Self Starter

Publish your first article on Hashnode and become a self starter!

Self Starter

Serial Blogger

Publish an article every day for 7 days and earn a cool serial blogger badge!

Serial Blogger

Talk of the town

Write a story that drives amazing engagement on Hashnode and become the talk of the town!

Talk of the town

Word Warrior

Write an in-depth article on your Hashnode blog that's more than 2000 words and become a word warrior!

Word Warrior

Mahdi Ahmadi

apexindubai.hashnode.dev·Jul 09, 2025

Jul 09, 2025

Securing Output in Oracle APEX with the APEX_ESCAPE Package

In the world of web development, safely displaying data is just as important as storing or processing it. Oracle APEX, a powerful low-code platform for building data-centric applications, includes a built-in package called APEX_ESCAPE designed specif...

Securing Output in Oracle APEX with the APEX_ESCAPE Package

Discuss·36 reads

Mahdi Ahmadi

apexindubai.hashnode.dev·Jul 09, 2025

Jul 09, 2025

Secure Password Hashing in Oracle PL/SQL using HMAC-SHA512

1. Introduction Password hashing is a critical part of building secure applications. In Oracle environments where advanced hashing functions like PKCS5_PBKDF2 are not readily available, it becomes essential to implement custom cryptographic solutions...

Secure Password Hashing in Oracle PL/SQL using HMAC-SHA512

Discuss·6 reads

Mahdi Ahmadi

apexindubai.hashnode.dev·Jul 09, 2025

Jul 09, 2025

Unlocking the Power of Build Options in Oracle APEX

A Smart Way to Control Feature Visibility Oracle APEX is full of powerful features that often fly under the radar. One such gem is Build Options — a feature that lets you control which parts of your app are active or visible without having to delete ...

Unlocking the Power of Build Options in Oracle APEX

Discuss·4 reads

Matt Mulvaney

mattmulvaney.hashnode.dev·Jul 07, 2025

Jul 07, 2025

Full Width Interactive Report Search Field

In this blog, I demonstrate how to always display a full width Interactive Report Search field regardless of the browser width, mobile or any CSS media queries. Here is what is looks like as standard Here is what it looks like with the modification ...

Full Width Interactive Report Search Field

Discuss·315 reads

Rafal Grzegorczyk

Rafal Grzegorczyk

rafal.hashnode.dev·Jul 05, 2025

Jul 05, 2025

Loki - Installation and configuration. No more code conflicts in the shared Oracle DEV Database.

In my previous blog post (link), you learned about Loki and how it can help you avoid conflicts in a shared Oracle development database. Now it’s time to learn how to install & set up Loki in your database. Requirements APEX 24.1.7 - Loki’s last vers...

Loki - Installation and configuration. No more code conflicts in the shared Oracle DEV Database.

Discuss·2 likes·97 reads

Rafal Grzegorczyk

Rafal Grzegorczyk

rafal.hashnode.dev·Jul 05, 2025

Jul 05, 2025

PROXY users in Oracle Database - what is it, why use it, and how can it help with my CI/CD process?

What is a proxy user? If you use a proxy user, you can connect to another database user without knowing their password. Why use a proxy user? I believe (and I’m not the only one) that giving developers, such as John and Rafal, passwords to, for examp...

PROXY users in Oracle Database - what is it, why use it, and how can it help with my CI/CD process?

Discuss·2 likes·162 reads

Johnny Hideki Kinoshita de Faria

Johnny Hideki Kinoshita de Faria

johnnyhideki.hashnode.dev·Jun 30, 2025

Jun 30, 2025

📦 Installing Oracle XE and Connecting with SQL Developer: From Download to Troubleshooting

Whether you're setting up a local Oracle database or connecting to it via SQL Developer, this guide has you covered—from the official installer to resolving common connection errors like ORA-12541. 🔽 1. Downloading and Installing Oracle XE 🔗 Offic...

📦 Installing Oracle XE and Connecting with SQL Developer: From Download to Troubleshooting

Discuss·7 reads

Tushar Jairam Kukreja

Tushar Jairam Kukreja

otmdebugdiary-tusharkukreja.hashnode.dev·Jun 28, 2025

Jun 28, 2025

OTM Migration: Solving Country Code Format Conflicts

How to handle 2-letter vs 3-letter country code mismatches during Oracle Transportation Management migrations 🩺 Symptoms The source OTM instance used 2-letter country codes (e.g., IN, US), while the destination was configured to use 3-letter codes...

OTM Migration: Solving Country Code Format Conflicts

Discuss·40 reads

BTS: OTM Troubleshooting

esProc

esproc-desktop.hashnode.dev·Jun 26, 2025

Jun 26, 2025

Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43

Problem Description & Analysis: A table in Oracle database has a column of datetime type, corresponding to multiple pieces of data per day: Task: Now we need to find two records every day, one closest to 8am that day and one closest to 8pm that day....

Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43

Discuss·10 likes·2 reads

Valter Zanchetti Filho

Valter Zanchetti Filho

tomeofapex.hashnode.dev·Jun 24, 2025

Jun 24, 2025

Creating and Configuring Wallets with OraPKI (Without Needing the Full Oracle Client)

I’ve often needed to deal with wallets in the database without having SSH access. So, to use mkstore or orapki locally, I had two main options: either download a database version and install it on a VM or local machine, or download and install the fu...

Creating and Configuring Wallets with OraPKI (Without Needing the Full Oracle Client)

Discuss·37 reads