Tag Archives: conversion failed

High Scale Number to Character conversion truncated in Oracle.

Posted on November 7, 2019 by Deepak Mahto

While trying to get max Scale for a Number Datatype in Oracle had observed internal truncation of data for conversion from NUMBER with higher precision and scale to Character Data Type. Let’s consider below NUMBER data for conversion to Character. … Continue reading →

Rate this:

Posted in Oracle Internal | Tagged , , , , | Leave a comment

#SQLSERVERLearning : CASE Statement Insight

Posted on December 16, 2016 by Deepak Mahto

All my blogs with #SQLSERVERLearning is intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for Oracle guy also working in SQL Server world. All finding or Observations with SQL Server … Continue reading →

Rate this:

Posted in SQL Server Learning | Tagged , , , , | Leave a comment