Why is to_char used when doing a divide by 0 in Oracle based SQLi?

1 vote

1 answer

149 views

                          For conditional-error-based SQLi, instead of writing 1/0 directly like MYSQL, we need to write to_char(1/0) for Oracle, what is the reason behind this? Example,

Oracle:

    SELECT CASE WHEN (YOUR-CONDITION-HERE) THEN TO_CHAR(1/0) ELSE NULL END FROM dual

Microsoft:

    SELECT CASE WHEN (YOUR-CONDITION-HERE) THEN 1/0 ELSE NULL END

Reference:

Asked by Vbr (11 rep)

Jan 23, 2023, 10:43 AM
Last activity: Jul 20, 2025, 11:04 AM

Why is to_char used when doing a divide by 0 in Oracle based SQLi?

Related Questions