в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:55:11Z

1 версия

Новая страница

==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>

==GREATEST() returns the greatest of the list of expressions.==



<source lang="sql">

SQL>
Syntax: GREATEST(<expression1>,<expression2>. . . <expression>)
SQL>
SQL> SELECT
2 GREATEST("ALEX","WALTER","PHILLIP") names,
3 GREATEST(10,20,135) numbers
4 FROM dual;
NAMES NUMBERS
------ ----------
WALTER 135
SQL>
SQL>
SQL>

</source>

==select greatest(==



<source lang="sql">

SQL>
SQL> select greatest( 1, 5, 10 )
2 from dual;
GREATEST(1,5,10)
----------------
10
1 row selected.
SQL>
SQL> --

</source>

==select greatest( "A", "a" )from dual;==



<source lang="sql">

SQL>
SQL> select greatest( "A", "a" )from dual;
G
-
a
1 row selected.
SQL>
SQL> --

</source>

==select greatest( "ONE", 1 )==



<source lang="sql">

SQL>
SQL> select greatest( "ONE", 1 )
2 from dual;
GRE
---
ONE
1 row selected.
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>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/Numeric Math Functions/greatest - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия