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 vote209 views1 answer
How to select even id in sql
SQL
0 vote227 views1 answer
How to get data from 2 database
SQL
1 vote229 views2 answers
Sql insert timestamp
SQL
0 vote201 views1 answer
Oracle sql date summer time
SQL
0 vote225 views1 answer
Find usage of table in sql server
SQL
0 vote204 views1 answer
Check if a word appears at the end sql query
SQL
0 vote229 views1 answer
Oracle swap partition
SQL
2 votes214 views1 answer
Query to find table size in oracle 12c
SQL
13 votes228 views2 answers
Sql join 3 tables
SQL
0 vote211 views1 answer
Casterar postgres
SQL