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

    Dynamic Sql instructions

    f97be60a-6d23-4403-9ace-3ce56554d59c

      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);
      begin
      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.