Oracle PL/SQL Tutorial/Miscellaneous Functions/GREATEST
Содержание
greatest(12*6,148/2,73)
<source lang="sql">
SQL> SQL> SQL> select greatest(12*6,148/2,73)
2 from dual;
GREATEST(12*6,148/2,73)
74
SQL></source>
GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)
<source lang="sql">
SQL> SQL> select greatest(12*6,148/2,73)
2 , least (12*6,148/2,73) 3 from dual;
GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)
--------------------
74 72
SQL> SQL></source>
This script demonstrates the Greatest functions
<source lang="sql">
SQL> SQL> SET SERVEROUTPUT ON SQL> DECLARE
2 v_char VARCHAR2(10); 3 v_number NUMBER(10); 4 BEGIN 5 6 v_char := GREATEST("A", "B", "C"); 7 v_number := GREATEST(1,2,3); 8 9 DBMS_OUTPUT.PUT_LINE("Greatest Character: "||v_char); 10 DBMS_OUTPUT.PUT_LINE("Greatest Number: "||v_number); 11 12 END; 13 /
Greatest Character: C Greatest Number: 3 PL/SQL procedure successfully completed. SQL> SQL></source>
Use the Greatest functions
<source lang="sql">
SQL> SQL> SQL> SET SERVEROUTPUT ON SQL> DECLARE
2 v_char VARCHAR2(10); 3 v_number NUMBER(10); 4 BEGIN 5 6 v_char := GREATEST("A", "B", "C"); 7 v_number := GREATEST(1,2,3); 8 9 DBMS_OUTPUT.PUT_LINE("Greatest Character: "||v_char); 10 DBMS_OUTPUT.PUT_LINE("Greatest Number: "||v_number); 11 12 13 END; 14 /
Greatest Character: C Greatest Number: 3 PL/SQL procedure successfully completed. SQL> SQL></source>