Sql cast to integer

-- NOTE: this is for SQL-Oracle specifically

/*
<...> : Your personal entry
*/

-- syntax:
CAST(<variable> as <variable-type>) -- in this case: <variable-type> = INTEGER

-- example:
SELECT CAST(MEMBER_NO as INTEGER)
FROM DUAL;

Similar codes

0 vote335 views1 answer
Mysql workbench format date
SQL
2 votes311 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote302 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote287 views1 answer
Where case insensitive like mysql
SQL
12 votes308 views10 answers
Google
SQL
0 vote290 views1 answer
Postgres where
SQL
3 votes275 views1 answer
Oracle function
SQL
6 votes318 views2 answers
Postgresql database url
SQL
0 vote291 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote299 views1 answer
How to print mysql query of codeigniter query builder
SQL