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 vote324 views2 answers
Check mysql timezone
SQL
4 votes327 views3 answers
NOT NULL SQL
SQL
3 votes336 views2 answers
Enter mysql command line
SQL
1 vote325 views1 answer
Sqlite3 read only
SQL
0 vote340 views1 answer
How to create a table based on another table in mysql
SQL
1 vote332 views1 answer
Join to find results not in another table
SQL
0 vote349 views1 answer
Mysql select random rows large table
SQL
3 votes333 views2 answers
Oracle drop column
SQL
0 vote354 views1 answer
Tinydb add table
SQL
1 vote318 views1 answer
How refresh navicat tables to see new tables
SQL