* 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;