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 vote264 views1 answer
Sql comand for removing data from table
SQL
53 votes405 views6 answers
Sql server alter column
SQL
0 vote246 views1 answer
Uuid sqlalcomany
SQL
0 vote262 views1 answer
Distinct data types in a table sql query
SQL
0 vote234 views1 answer
Lister les index d'une table oracle
SQL
2 votes277 views1 answer
Oracle block
SQL
0 vote243 views1 answer
Oracle flush Shared Pool
SQL
4 votes243 views1 answer
Sql group by year
SQL
0 vote250 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote246 views1 answer
Postgresql log
SQL