1 Reply Latest reply: Feb 20, 2012 6:16 AM by EdStevens RSS

    Multiple OR conditions with IF statement

    595582
      Hello,

      Please is this statement possible, and does it have performance issues in the database?

      IF v_name is null OR v_age is null OR v_comm is null OR v_sal is null
      THEN
      ..........

      Thanks
        • 1. Re: Multiple OR conditions with IF statement
          EdStevens
          user592579 wrote:
          Hello,

          Please is this statement possible, and does it have performance issues in the database?

          IF v_name is null OR v_age is null OR v_comm is null OR v_sal is null
          THEN
          ..........

          Thanks
          Is it possible?
          Does your organization impose a penalty for trying it for yourself?

          BTW, that is a question about the SQL Language, not the sqlplus tools. Better posted in PL/SQL