Function - Scalar & Aggregate
select substr("Oracle World",1,6) from dual;
Oracle
World
Oracle W
racle W