Home/ Questions/Q 3856
Next
Answered
Question
albert
  • 0
Explorer
Asked: 2016-08-01T18:13:11+03:00 In:

Can i use select statement inside if statement ? (if (select) > 0 then) ?

  • 0

hello can I use select inside if statement like :

begin
if (select count(*) from employees) >= 15 then
do something;
end if;
end;

 

note : I want to delete rows from table where above condition evaluates with true

ifif statementoraclepl/sqlselect
Share

    Related Questions

    1 Answer

    1. Best Answer
      Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

      hello Beter,
      you can’t use SQL Statement directly in a PL/SQL expression instead you can use variable to store your count then use your variable into PL/SQL expression like this :

      DECLARE
        v_count   NUMBER;
      BEGIN
        SELECT count (*) INTO v_count FROM dual;

        IF v_count >= 1 THEN
          dbms_output.put_line ('true');
        ELSE
          dbms_output.put_line ('false');
        END IF;
      END;

      or as you mentioned if you want to use it inside delete statement like this :

      DELETE FROM table_1
      WHERE       (SELECT count (*) FROM table_2) >= 1;

      hope this helpful 🙂

      • 0

    Leave an answer

    You must login to add an answer.

    Need An Account,