Java bro

Java tutorial

Sql queries

Convert varchar to number

In this tutorial we are going to cast varchar to number. See the below example.

Syntax:

SELECT CAST(’12’ AS NUMBER) FROM DUAL;
Parameter should contain numbers only. Trailing spaces are allowed .

Comments are Closed

Theme by Anders Norén