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 vote97 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote102 views1 answer
Sql date d'aujourd'hui
SQL
3 votes110 views2 answers
Postgres alter table owner
SQL
0 vote102 views1 answer
Column ' ' in field list is ambiguous
SQL
5 votes99 views5 answers
Find max number in sql
SQL
0 vote115 views2 answers
Starts and end with vowel sql
SQL
4 votes114 views1 answer
W3schools create table
SQL
9 votes248 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote108 views1 answer
Sql find all different values in column
SQL
0 vote101 views2 answers
Mysql dump database tables only
SQL