2 Replies Latest reply on Oct 25, 2016 3:49 PM by Asterix45

    Dynamic Sql instructions


      Hi all,

      First sorry for my English if there is some mistakes.

      In a professional project, I want to give as a parameter to a stored procedure oracle, a list of SQL statements containing SELECT to execute them and get the results.

      Example for parameter :
      "declare csSelect varchar(4000);
      csSelect := 'SELECT * FROM JOURNAL';
      if 'A' != '%' then
          csSelect := csSelect || 'WHERE JOURNAL.NOM LIKE ''A%'' ';
      end if;

      I need this for oracle and sqlserver. I found for sqlserver but not for oracle.