* MAX *
select max(CREDIT_LIMIT)
from DEMO_CUSTOMERS
* MAX SEARCH PROCESS *
Begin
Select CUST_FIRST_NAME, CUST_LAST_NAME, CREDIT_LIMIT into :p1_max_First_NAME, :p1_max_last_NAME, :p1_max_credit_LIMIT from DEMO_CUSTOMERS
where CREDIT_LIMIT = (select max (CREDIT_LIMIT)
from DEMO_CUSTOMERS ) and rownum = 1;
end;
* MAX PROCESS *
Begin
Select ENAME, SAL, job into :p16_max_NAME, :p16_max_salary, :p16_title from EMP
where SAL = (select max (SAL)
from EMP)
and rownum = 1;
end;
No. | Subject | Author | Date | Views |
---|---|---|---|---|
29 | What Is ERP? | admin | 2018.02.14 | 136 |
28 | Reversing Require HTTPS | admin | 2023.06.04 | 131 |
27 | LOOP TABLE UPDATE | admin | 2023.05.19 | 130 |
26 | SQL Basics - Lesson 1 - Introduction | admin | 2017.06.17 | 127 |
25 | 127.0.0.1:8080/apex/ | admin | 2023.06.03 | 120 |
24 | image (products) | admin | 2017.11.24 | 119 |
23 | Monthly SUM | admin | 2023.05.22 | 117 |
22 | Apex Interactive Report: The difference between CIR and RIR | admin | 2018.01.26 | 114 |
21 | Material requirements planning (MRP) | admin | 2018.02.14 | 111 |
20 | Link- AbbaBeauty | admin | 2018.02.13 | 111 |
19 | CHANGE TABLE NAME | admin | 2023.05.31 | 108 |
18 | ipconfig | admin | 2023.06.03 | 105 |
17 | Manufacturing resource planning (MRP II) | admin | 2018.02.14 | 96 |
16 | Building Mobile Applications with Oracle Application Express 5.0 | admin | 2017.11.25 | 96 |
15 | TEST | admin | 2023.04.28 | 90 |
14 | GP - 영수증 (2) | admin | 2022.11.07 | 89 |
13 | GP 영수증 본문 | admin | 2022.11.07 | 88 |
12 | GP 영수증 (3) -01/04/2023 | admin | 2023.01.04 | 86 |
11 | INNER JOIN | admin | 2023.05.19 | 85 |
10 | WHDR email address | admin | 2023.04.13 | 84 |