Blog

This guide provides step-by-step instructions to set up SFTP access for a specific user (`ftpuser`) restricted to a specific folder (e.g., `/var/www/mobile_proxy/tmp/test_folder/`) on Rocky Linux. It includes configuration for SSH chroot jail, permissions, and diagnostics for common issues.

Analysis of SQL query optimization in Oracle EBS using EXPLAIN PLAN, where implicit type conversion causes slowdown, and the solution with TO_CHAR for efficient index usage.

I identified the main bottlenecks (repeated XML parsing with xmltype.extract), proposed a fix using `XMLTABLE` and a single, set-based `MERGE`, and included example SQL and index recommendations.

Base64 and HEX are ways to represent raw bytes as text. In API integrations you often need to choose the right format to transfer binary data (RAW / BLOB) and the correct text encoding. This article provides clear explanations and working examples for Oracle (PL/SQL).

This article explores the concept of horizontal attribute storage in Oracle databases. It explains how to store dynamic attributes as rows instead of columns, provides practical examples, and compares horizontal storage with traditional vertical storage. Learn about its advantages, disadvantages, and SQL techniques for data transformation.

A practical solution for scenarios where you need to change the data source in Oracle without modifying the main procedure code. A simple approach using views (VIEW) for seamless switching between old and new data.