Skip to content
Java bro

Java full stack tutorial

  • Home
  • Java
    • Core java
    • Advance java
    • Java examples
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Struts 1.x
    • Struts 2.x
    • Hibernate
    • TypeScript
    • Angular
    • ReactJs
  • Spring
    • Spring core
    • Spring DAO
    • Spring ORM
    • Spring AOP
    • Spring MVC
    • Spring Boot
  • Micro services
    • Zuul
    • Cloud config server
    • Hystrix
    • Kafka
    • Redis cache
    • Sleuth
    • Zipkins
  • Interview Q&A
    • Java
    • Jdbc
    • Servlets
    • Jsp
    • Struts
    • Hibernate
    • Spring
    • Micro services
    • Angular
    • React Js
  • Others
    • Servers
    • IDEs
    • Java practice
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge
Java bro

Java full stack tutorial

  • Home
  • Java
    • Core java
    • Advance java
    • Java examples
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Struts 1.x
    • Struts 2.x
    • Hibernate
    • TypeScript
    • Angular
    • ReactJs
  • Spring
    • Spring core
    • Spring DAO
    • Spring ORM
    • Spring AOP
    • Spring MVC
    • Spring Boot
  • Micro services
    • Zuul
    • Cloud config server
    • Hystrix
    • Kafka
    • Redis cache
    • Sleuth
    • Zipkins
  • Interview Q&A
    • Java
    • Jdbc
    • Servlets
    • Jsp
    • Struts
    • Hibernate
    • Spring
    • Micro services
    • Angular
    • React Js
  • Others
    • Servers
    • IDEs
    • Java practice
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge
  • Home
  • Java
    • Core java
    • Advance java
    • Java examples
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Struts 1.x
    • Struts 2.x
    • Hibernate
    • TypeScript
    • Angular
    • ReactJs
  • Spring
    • Spring core
    • Spring DAO
    • Spring ORM
    • Spring AOP
    • Spring MVC
    • Spring Boot
  • Micro services
    • Zuul
    • Cloud config server
    • Hystrix
    • Kafka
    • Redis cache
    • Sleuth
    • Zipkins
  • Interview Q&A
    • Java
    • Jdbc
    • Servlets
    • Jsp
    • Struts
    • Hibernate
    • Spring
    • Micro services
    • Angular
    • React Js
  • Others
    • Servers
    • IDEs
    • Java practice
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge

Convert varchar to number

  • Home
  • Sql queries
  • Convert varchar to number
  • Sql queries
  • vsreenu48
  • May 2, 2020November 23, 2020
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 .
Prev post Convert varchar to sql tmestamp
Next post Convert Long values to LOB values in sql

Recent Posts

  • TypeError: First argument must be a string in React
  • Create a thread by implementing Runnable interface
  • Create a thread by extending Thread class
  • Life cycle of a thread
  • Introduction to multi threading in java
  • List Interface in java
  • Collection Interface in java
  • Hierarchy of collection framework

Popular posts

  • JBAS011232: Only one JAX-RS Application Class allowed 507 views
  • Type ‘Promise‘ is not assignable to type ‘string[]’ 300 views
  • Convert NCLOB vlaues to CLOB ins sql 300 views
  • Convert Long values to LOB values in sql 200 views
  • Get last date of month in sql 200 views
  • Get today date in sql 200 views
  • Swap two numbers in java 101 views
  • jspService is exceeding the 65535 bytes limit 101 views

Views

4439

Orchid Store Theme by Themebeez