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

4 votes153 views1 answer
Wilayah indonesia database
SQL
0 vote165 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote160 views1 answer
Mysql average from two table
SQL
0 vote139 views1 answer
Fetch second word from a string in ms sql
SQL
2 votes162 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote156 views3 answers
Database restoring error
SQL
0 vote155 views1 answer
Function sum(text) does not exist postgres
SQL
15 votes186 views5 answers
Show tables in oracle
SQL
-1 vote148 views1 answer
Sql oracle take only last results
SQL
0 vote157 views3 answers
Drop multiple columns in sql
SQL