«Back to Home

Oracle Jump Start
Topics

How To Use Least Function In OraclePLSQL

Description
 
This function returns the smallest value in Oracle/PLSQL.
 
Syntax
  1. Least (Expression1, expression 2…..expression n)  
Example
  1. Select Least (2, 5, 1, 3, 4 )  
  2. from Dual;  
1

Example 
  1. select LEAST('apples', 'oranges', 'bananas')  
  2. from Dual;  
2

Example
  1. Select LEAST('2', '5', '12', '3')  
  2. From Dual;  
3

Summary
 
Thus, we learnt, Least function returns the smallest value in Oracle/PLSQL. We learnt, how to use Least function with the examples.