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 vote140 views1 answer
Get create sql of hibernqte entity
SQL
0 vote121 views1 answer
Equi joins in oracle
SQL
-1 vote122 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote136 views2 answers
How to get max from each department in sql
SQL
7 votes129 views1 answer
Set sequence value oracle
SQL
0 vote131 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote130 views1 answer
Where name ends in SQL
SQL
0 vote129 views1 answer
Select * from mysql.proc
SQL
7 votes116 views3 answers
Add primary key to database sql
SQL
0 vote133 views1 answer
Sql use with to get value counts and percentages
SQL