Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql trim whitespace 
Sql :: mysql set primary key 
Sql :: how to update column name in psql 
Sql :: mysql sysdate 
Sql :: import file mysql terminal 
Sql :: mysql select where not in multiple tables 
Sql :: show all public tables postgres 
Sql :: mysql connection string 
Sql :: display index in sql 
Sql :: sql last 3 rows 
Sql :: oracle alter tablespace add datafile autoextend max size 
Sql :: create function in microsoft sql server 
Sql :: sql auto date 
Sql :: size of all tables in a schema oracle 
Sql :: data directory postgresql 
Sql :: not operator in oracle 
Sql :: Incorrect format parameter 
Sql :: mysql jdbc timezone 
Sql :: purge undo tablespace oracle 11g 
Sql :: Select last row from SQL Table 
Sql :: add column not null with default value postgres 
Sql :: sql create a new table 
Sql :: oracle plsql sleep 
Sql :: ORA-00942 
Sql :: phone number sql 
Sql :: sql server: difference between hashtable and table declared using declare keyword 
Sql :: flask sqlalchemy filter multiple conditions 
Sql :: foreign key mysql 
Sql :: get primary key of table 
Sql :: date to string mariadb 
ADD CONTENT
Topic
Content
Source link
Name
8+2 =