how to create a alias in sql code example

Example: sql alias

-- SELECT my_col_name AS my_alias FROM my_table;
SELECT sysdate() AS "Current date";   			-- MySQl Alias
SELECT sysdate AS "Current date" FROM dual;   	-- same in Oracle