Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Dynamic Sql instructions

f97be60a-6d23-4403-9ace-3ce56554d59cAug 8 2016 — edited Oct 25 2016

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 22 2016
Added on Aug 8 2016
2 comments
424 views