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 vote122 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote123 views1 answer
Sql server inner join convert collation
SQL
2 votes125 views2 answers
Spring import sql
SQL
-1 vote174 views1 answer
Difference berween database and data base management system
SQL
-1 vote134 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote136 views1 answer
Excel export from sql using python
SQL
0 vote129 views1 answer
Convert sql server guid to varbinary
SQL
1 vote84 views1 answer
Postgres reset auto increment
SQL
0 vote138 views1 answer
Drop all triggers oracle
SQL
1 vote131 views1 answer
Sql server cast date dd/mm/yyyy
SQL