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 vote274 views1 answer
Sql filter rows with condition
SQL
2 votes230 views3 answers
Oracle show column of table
SQL
0 vote199 views1 answer
Mysql date only no time
SQL
0 vote196 views1 answer
Default order by in mysql
SQL
0 vote212 views1 answer
Postgresql list extensions
SQL
0 vote198 views1 answer
How to save data in database in mysql node
SQL
0 vote261 views1 answer
Sql decimal to 2 places
SQL
0 vote187 views1 answer
Update using case in mysql
SQL
1 vote206 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote191 views5 answers
Linq cheat sheet
SQL