Skip to content
Java bro

Java full stack tutorial

  • Home
  • Java
    • Core java
    • Advance java
    • Java 8
    • Java examples
    • Java Puzzles
    • Java practice
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Hibernate
    • ReactJs
    • Angular
    • Struts 1.x
    • Struts 2.x
    • TypeScript
  • 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
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge
Java bro

Java full stack tutorial

  • Home
  • Java
    • Core java
    • Advance java
    • Java 8
    • Java examples
    • Java Puzzles
    • Java practice
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Hibernate
    • ReactJs
    • Angular
    • Struts 1.x
    • Struts 2.x
    • TypeScript
  • 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
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge
  • Home
  • Java
    • Core java
    • Advance java
    • Java 8
    • Java examples
    • Java Puzzles
    • Java practice
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Hibernate
    • ReactJs
    • Angular
    • Struts 1.x
    • Struts 2.x
    • TypeScript
  • 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
    • 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

  • Equality operator in java
  • Assignment operators in java
  • Increment-decrement operators in java
  • Relational operators in java
  • Arithmetic operators in java
  • Operators in java
  • Floating point literals in java
  • Boolean literals in java

Popular posts

  • JBAS011232: Only one JAX-RS Application Class allowed 607 views
  • Type ‘Promise‘ is not assignable to type ‘string[]’ 300 views
  • Convert NCLOB vlaues to CLOB ins sql 300 views
  • Get today date in sql 200 views
  • Get last date of month in sql 200 views
  • Convert Long values to LOB values in sql 200 views
  • Integral data types in java 104 views
  • Should not consume any form parameter 101 views

Views

6598

Orchid Store Theme by Themebeez