Oracle PL/SQL Min Function The Min function returns the minimum value of an expression. The Min Function syntax: Select min(exp ) From table Where condition; Example 1: Select min(e.sal) From emp e Where e.job='CLERK'; 800 Example 2: Select e.ename, e.sal From...
Oracle PL/SQL Median Function The Median function returns the median of an expression. The Median Function syntax: median(expression) or median( expression ) [ OVER ( query partition clause ) ] Example 1: Select median(e.sal) From emp e Where e.job='CLERK' Example 2:...
Oracle PL/SQL Max Function The Max function returns the maximum value of an expression. The Max Function syntax: Select max(exp ) From table Where condition; Example 1: Select max(e.sal) From emp e Where e.job='CLERK'; 1300 Example 2: Select e.ename, e.sal From...
Oracle PL/SQL Ltrim Function The Ltrim function removes all specified characters from the left-hand side of a string. The Ltrim Function syntax: ltrim( string, [ trim_text ] ) String is the string to trim the characters from the left-hand side. Trim_text...
Oracle PL/SQL Lpad Function The Lpad function pads the left-side of a string with a specific set of characters. The Lpad Function syntax: lpad( text, length, [ pad_text ] ) Pad_text is optional, is the string that will be padded to...