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.