Articles

TCH

ZA Zahir Mohideen

Case Sensitiveness — Part 2

Oracle maintains the case sensitiveness by default.

Aug 11, 2026 · 2 min read · 0 claps #oracle-database #database-administration #database-development

ZA Zahir Mohideen

How to format Zipcode / Postal Code in Oracle

Sometimes , in the applications , zipcodes are stored as numbers . That means , the leading zeros for some of the postal codes will not be…

Aug 09, 2026 · 1 min read · 0 claps #oracle-database #sql #oracle-pl-sql

SPT

ZA Zahir Mohideen

dbms_output in SQL Developer

In sqlplus , you can shorten some of the SET options and it works the same as if the full command is issued.

Aug 08, 2026 · 1 min read · 0 claps #oracle-database #sqlplus #sql-developer

ZA Zahir Mohideen

XML Schema Support in SQL Server.

SQL Server has increased it support for XML version after version . From SQL Server 2005 onwards , we can declare xml schema as schema…

Aug 08, 2026 · 1 min read · 0 claps #microsoft-sql-server #xml #database-administration

ZA Zahir Mohideen

RMAN Enhancements in 12c — Part 1

To execute a SQL statement in RMAN prompt , we would need to prefix “sql” in Oracle 11g and below . In Oracle 12c , we can issue sqls…

Aug 07, 2026 · 1 min read · 0 claps #oracle-database #database-administration #rman

ZA Zahir Mohideen

Real Time Monitoring / Tracing

I have to say , DBMS_APPLICATION_INFO is one of the under utilized package from Oracle . This is very valuable in tracing , identifying the…

Aug 06, 2026 · 1 min read · 0 claps #application-monitoring #sql-training #oracle-database

ZA Zahir Mohideen

Native Compilation

11g Release 1 and above introduced the real “native” compilation for PL/SQL objects . Prior to this release , when we compile the objects…

Aug 06, 2026 · 2 min read · 0 claps #oracle-database #native-compilation #oracle-pl-sql

ZA Zahir Mohideen

Aggregation Filter in Oracle AI 26 ai

Aggregation filter is yet another neat addition to the SQL in Oracle AI 26 ai. This feature makes the SQL concise , easier to read.

Aug 05, 2026 · 1 min read · 0 claps #oracle-database #sql #database-development

ZA Zahir Mohideen

FETCH X ROWS in Oracle 12c ( New Feature !)

Oracle 12c has introduced “FETCH” n rows clause in the SELECT statement. Though , it is a “new” feature , Oracle seems to be doing the same…

Aug 04, 2026 · 2 min read · 0 claps #oracle-database #oracle-sql #sql-window-functions

LIF ECO

HA Haris Moideen

Why Kerala’s Startup Scene Needs More Angel Investors They Actually Build

Kerala has never been short in ideas. From spice exporters in Kerala to D2C food brands shipping across the Gulf, the state has a quiet…

Aug 04, 2026 · 4 min read · 0 claps #angel-investors #angel-investing #angel-investment

ZA Zahir Mohideen

Dynamic Sort

Let us say we have a requirement to sort the result set based on the given input parameter . In most of the system , the developers…

Aug 03, 2026 · 3 min read · 0 claps #oracle-database #database-security #sql-injection

ZA Zahir Mohideen

How to Drop Oracle Database.

RMAN is not only for backup and recovery . RMAN can be used to drop the database ( data files and log files ,…) .

Aug 01, 2026 · 1 min read · 0 claps #oracle-database #database-administration #database-backup

ZA Zahir Mohideen

How to store rounded number in Oracle ?

If you have a requirement to store the numbers rounded to nearest hundreds , what would be the easy way. You can satisfying this…

Jul 31, 2026 · 1 min read · 0 claps #oracle-database #database-development #database-design

AI

ZA Zahir Mohideen

Interval Partitioning

Oracle 11g has a new feature that will make life easier for the DBAs. Prior to this release , the DBAs must make sure they create a new…

Jul 31, 2026 · 4 min read · 0 claps #oracle-database #database-administration #partition

ME Mein Herzuniversum Inspiration für Vielbegabte

Welche Idee klopft immer wieder an?

Vielleicht kennst du diesen Moment: Du hast viele Ideen im Kopf, aber sobald du dich für eine entscheiden möchtest, werden auch alle…

Jul 24, 2026 · 2 min read · 150 claps #ideenvielfalt #adh #taussendsassa

MU muhammad zain ul abideen

Cost to Replace a Roof in 2026: Complete Price Guide

Roof replacement costs $4,000–$33,000 in 2026 depending on size, material, and location. See real pricing tables by material, size, and…

Jul 23, 2026 · 4 min read · 0 claps #roofing #asphalt-shingles #roofing-estimate

ZA Zahir Mohideen

Compatibility Issues with MS Access and SQL Server

In most organizations , Power Users use MS Access to query the data from other RDBMS (via ODBC) for their reporting needs. For this…

Jul 13, 2026 · 2 min read · 0 claps #microsoft-sql-server #microsoft-access #sql

ZA Zahir Mohideen

Minimize logging for Data Pump Import — IMPDP

Starting in Oracle 12c, we can disable ( well … minimize) the logging by setting the new setting in the TRANFORM parameter . Logging is not…

Jul 11, 2026 · 2 min read · 0 claps #oracle-database #export-data #data-import-and-export

ZA Zahir Mohideen

Data Redaction in Oracle

In one of my previous post on column masking , I was explaining about using VPD to mask the sensitive columns for compliance and regulatory…

Jul 09, 2026 · 3 min read · 0 claps #database-security #oracle-database #vpd

ECO

ZA Zahir Mohideen

External table Enhancements in Oracle 12c

One of the External tables’ enhancements in Oracle 12c is the ability to use wildcard characters in defining the data sources. We can have…

Jul 07, 2026 · 1 min read · 0 claps #oracle-database #database-administration #data-import-and-export

ZA Zahir Mohideen

ORA-01720 … Error while recreating a view in 12c

We were testing some of my scripts for 12c upgrade . There were few changes to few views . So , we changed the script and deploy it .

Jul 05, 2026 · 1 min read · 0 claps #oracle-database #sql #database-development

ZA Zahir Mohideen

NOLOCK …. Think twice

Not all the RDBMS are the same.

Jul 04, 2026 · 3 min read · 0 claps #sql-server #rdbms #isolation-level

ART MDA

MO mohamed mohideen

Why I Switched to Cold Pressed Coconut Oil for My Hair (And What I Wish I’d Known Sooner)

A short, honest take on why the extraction method matters more than the brand name on the bottle

Jul 04, 2026 · 2 min read · 0 claps #coconut-oil #hair-care #natural-beauty

ZA Zahir Mohideen

Fixing “DBProviderFactories” section issue in SSDT / SSIS / SSMS

Recently , I installed SQL Server Data tools ( SSDT) after installing SQL Server 2014 .

Jun 29, 2026 · 1 min read · 0 claps #microsoft-sql-server #sql-server-integration #sms

HUM ECO

ZA Zahir Mohideen

Rolling Back a DDL

Not all the RDBMS are same . Even though , there have similar syntax / features , they differ how they handle transactions / locking / DDLs…

Jun 29, 2026 · 2 min read · 0 claps #acid #transaction-isolation #oracle-database

AI

ZA Zahir Mohideen

Implementation difference between PostgreSQL and MS SQL Server in varchar with no length

Today , I learned something new in PostgreSQL. Surprised to see the implementation difference between PostgreSQL and MS SQL Server .

Jun 27, 2026 · 2 min read · 0 claps #postgresql #microsoft-sql-server #rdbms

AI SCI

ZA Zahir Mohideen

R Dataframe in the eyes of SQL developer

R has gained lot of momentum in the last few years for Data Science. At first , for a SQL professional , this may be bit daunting ; however…

Jun 26, 2026 · 2 min read · 0 claps #data-science #r-language #dataframes

ZA Zahir Mohideen

Schema only user accounts in Oracle

Prior to Oracle 18c , there is no difference between user and schema . It has been used interchangeably .

Jun 25, 2026 · 1 min read · 0 claps #oracle-database #users #schema

ZA Zahir Mohideen

GROUP BY behavior in MySQL / MariaDB

It is better to unlearn and relearn the SQL , if we need to work on different DBMS. I was surprised by the “GROUP BY” behavior in MySQL /…

Jun 24, 2026 · 4 min read · 0 claps #sql #group-by-clause #mysql

ZA Zahir Mohideen

Windowing Clause … Why it matters

Windowing clause in Analytical ( Oracle ) / Windows functions ( SQL Server ) plays an important role of how the results are rendered. This…

Jun 24, 2026 · 4 min read · 0 claps #sql-window-functions #analytical-function #sql

MED

KL Klimbim

Schmuck für ihn: Geschenkideen, die Stil und Alltag verbinden

Schmuck für Männer ist heute weit mehr als ein Accessoire für festliche Anlässe. Ein schlichtes Armband, eine reduzierte Kette oder ein…

Jun 21, 2026 · 3 min read · 0 claps

ZA Zahir Mohideen

Oracle 23c New Feature — Grouping by an alias

Probably , this is my shortest blog post till now. In Oracle 23c , we can group by the alias name . This simple enhancement improves…

Jun 20, 2026 · 1 min read · 0 claps #oracle-database-23ai #mariadb #sql

ZA Zahir Mohideen

Naming Window Clause in SQL Server 2022 Window / Oracle 23c Analytical Functions

One of my favorites in database development is “Analytical Functions” ( Oracle ) and “Window Functions” ( SQL Server / MariaDB).

Jun 20, 2026 · 3 min read · 0 claps #oracle-database #microsoft-sql-server #sql-window-functions

ZA Zahir Mohideen

DB_DEVELOPER_ROLE in Oracle 23 ai

Oracle 23 ai introduced a new role called ‘DB_DEVELOPER_ROLE’ .

Jun 19, 2026 · 2 min read · 0 claps #oracle-database #roles-and-grants #oracle-database-23ai

AI TCH

ZA Zahir Mohideen

Strange issue with Informatica Secure Agent Installation

Most of the time , copy and paste is a life saver. Sometimes , this could get tricky.

Jun 19, 2026 · 2 min read · 0 claps #iic #informatica #agent-installation

MKT SPT

ZA Zahir Mohideen

Scalar SQL Macro and DUAL in 23c

In the previous post on SQL Macros ( https://medium.com/@zahirmohideen/sql-macros-f1ce85e3b9ec ) , I was exploring SQL macros.In Oracle 23c…

Jun 18, 2026 · 1 min read · 0 claps #sql-macros #sql #oracle-ai-database

ZA Zahir Mohideen

SQL Macros

SQL Macros was introduced in Oracle 21c. There are two types of SQL Macros in 21c ( Scalar and Table). These enhancements make it easy to…

Jun 18, 2026 · 3 min read · 0 claps #sql-macros #sql #oracle-ai-database

ZA Zahir Mohideen

JSON Duality View in Oracle 23 ai

Oracle 23ai introduced “JSON-Relational Duality” Views. With this feature , the existing relational structure can be retrieved as a JSON…

Jun 17, 2026 · 2 min read · 0 claps #oracle-23ai #sql #json

ZA Zahir Mohideen

Group by ‘Column Position’ in Oracle 23 ai

In the previous post , we were introduced to a minor enhancement to the group by clause.

Jun 17, 2026 · 1 min read · 0 claps #oracle-23ai #sql #aggregation

ZA Zahir Mohideen

Oracle 23ai New Features.

Oracle 23ai New Features.

Jun 16, 2026 · 2 min read · 0 claps #oracle-database-23ai #new-features #sql

HUM

ZA Zahir Mohideen

Tableau LOD Calculations Explained with Ranking / Window functions

I started my learning journey with Tableau few months ago.

Jun 15, 2026 · 3 min read · 0 claps #tableau #lod #sql

SCI

ZA Zahir Mohideen

Hybrid Read Only in Oracle 23 ai

“Hybrid Read only mode” one of the nicest improvements in Oracle 23ai.

Jun 14, 2026 · 2 min read · 0 claps #oracle-database #database-administration #tablespace

TCH

ZA Zahir Mohideen

Enhancement in Direct Path Insert — Oracle 23 ai Feature

This is one another nice feature introduced in 23ai.

Jun 14, 2026 · 1 min read · 0 claps #oracle-database #etl #sql

ZA Zahir Mohideen

Read Only USER and SESSION in Oracle 23 ai

In one of the previous post , I described about placing PDBs in “hybrid read only”. In this post , we will another “read only” feature from…

Jun 13, 2026 · 3 min read · 0 claps #oracle-database #oracle-database-23ai #new-features

ZA Zahir Mohideen

ANY_VALUE in Oracle 19c

Oracle 21c introduced the “ANY_VALUE” function . And it is backported to 19c as well. Per Oracle’s documentation , this function is…

Jun 13, 2026 · 2 min read · 0 claps #oracle-database #sql #new-features

ZA Zahir Mohideen

QUALIFY in Oracle Database 26 ai

Oracle AI database 26 ai introduced a new SQL verb “QUALIFY”. With this addition , the SQL can be concise , clear and readable.

Jun 12, 2026 · 1 min read · 0 claps #oracle-database #analytical-function #sql

ZA Zahir Mohideen

Aggregation Filter in Oracle AI 26 ai

This post is quick one!

Jun 11, 2026 · 1 min read · 0 claps #oracle-ai-database #new-features #sql

AI SCI

ZA Zahir Mohideen

Stored procedure cannot be the input to the Python script in MS SQL Server

I am in the journey of using python in MS SQL Stored procedures.

Jun 10, 2026 · 1 min read · 2 claps #python #microsoft-sql-server #stored-procedure

ZA Zahir Mohideen

Accessing Postgresql / MySQL / MS SQL Server from Oracle

Gone are the days , where a business has only one DBMS to maintain its operations.

Jun 08, 2026 · 2 min read · 0 claps #heterogeneous-computing #database-administration #linked-server

ZA Zahir Mohideen

Oracle’s Analytical functions Vs SQL Server’s Windowing Functions

With the release of SQL Server 2012 , SQL Server has caught up with Oracle’s implementation of Analytical functions , there are few subtle…

Jun 07, 2026 · 2 min read · 0 claps #oracle-database #sql-server #analytical-function