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 vote142 views1 answer
Sql missing values
SQL
0 vote136 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
-1 vote189 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote152 views2 answers
Dbms interview questions
SQL
0 vote140 views1 answer
Procedure excute monthly oracle
SQL
0 vote136 views1 answer
Oracle sql winter time change
SQL
0 vote149 views1 answer
Delete ids between sql
SQL
0 vote135 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
4 votes150 views1 answer
T-sql get duplicate rows
SQL
15 votes167 views4 answers
Sql update from select
SQL