This is a document Template
 
Oracle Cast

SELECT ename, sal,CAST(sal AS VARCHAR2(10)) "c-sal"from emp where rownum < 7

SELECT ename, CAST(sal AS Integer) "Int_sal" FROM emp where rownum < 7

SELECT ename, CAST((sal * 0.25)AS float) "Int_sal" FROM emp where rownum < 7

 
select bin_to_num(1) from dual
Oracle

postgresql
mysql: not available