Character function , Number function, Date function
Character functions Ø Select LOWER (ename) from emp; it displays letters in lowercase Ø Select UPPER (ename) from emp; it displays letters in uppercase Ø Select INITCAP (ename) from emp; it displays 1 st letter capital Ø Select CONCAT (ename, job) from emp; it combines two columns Ø Select SUBSTR (ename,2) from emp; it displays ename from 2 nd letter Ø Select SUBSTR (ename,1,3) from emp; it displays ename from 1 st letter to 3 rd letter Ø Select LENGTH (ename) from emp; Ø Select ename, INSTR (ename, ‘S’, 2,1) from emp; it displays letter S count from 2 nd position of 1 st S in the string Ø Select ename, INSTR (ename,’S’,1,2) from emp; it displays letter S count from 1 st position to 2 nd S in the string Ø Select ename, INSTR (ename, ‘L’, -2,1) from emp; it displays letter L count from Last position of 1 st L in the string Ø Select LPAD (ename,20.’@’) from emp; it disp...