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 vote334 views1 answer
Mysql last 6 months
SQL
5 votes363 views1 answer
Oracle ora-00054 find
SQL
0 vote316 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote406 views1 answer
Difference between where and having clause
SQL
0 vote302 views1 answer
Mysql drop multiple tables at once
SQL
3 votes306 views1 answer
Oracle apex warning message
SQL
0 vote323 views1 answer
Start stop mysql linux
SQL
0 vote332 views1 answer
Mysql where in maintain order
SQL
6 votes316 views4 answers
Remove spaces sql server
SQL
0 vote318 views2 answers
Sql trigger difference between for and after
SQL