column alias:
select empno "eid",ename, mgr,hiredate "hire", deptno "dept" from emp
Oracle:
PostgreSQL:
MYSQL: