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 votes259 views3 answers
Mysql modify foreign key
SQL
0 vote267 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote254 views1 answer
Default value false mysql
SQL
2 votes267 views1 answer
Mysql clear screen
SQL
0 vote281 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote260 views1 answer
Do postgresql
SQL
1 vote284 views1 answer
Mysql connect bash
SQL
18 votes249 views2 answers
Sql comments
SQL
0 vote260 views1 answer
Postgresql default value boolean
SQL
6 votes263 views1 answer
Phpmyadmin password root
SQL