Answers for "function vs procedure in oracle sql"

oracle procedure as vs is

FUNCTION sal_ok (salary REAL, title VARCHAR2) RETURN BOOLEAN IS
   min_sal REAL;
   max_sal REAL;
BEGIN
   SELECT losal, hisal INTO min_sal, max_sal FROM sals
      WHERE job = title;
   RETURN (salary >= min_sal) AND (salary <= max_sal);
END sal_ok;

Posted by: Guest on October-07-2020

Code answers related to "function vs procedure in oracle sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "function vs procedure in oracle sql"

Code answers related to "function vs procedure in oracle sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "function vs procedure in oracle sql"

Code answers related to "function vs procedure in oracle sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us