Re: Workbench Query Using Complex Variables
Mike
Thanks for your comment. I will try the approach below in the variable string using the following:
SET @org1 = '3';
SET @org2 = '4';
SET @org3 = '5';
'' '' '' '' ''
SET @org7 = '9';
and use:
AND cl_org_cd NOT IN (@org1,@org2,@org3,...,@org7) );
Hopefully it will work.
Russell
Subject
Views
Written By
Posted
1829
October 23, 2016 12:45PM
611
October 24, 2016 01:13AM
Re: Workbench Query Using Complex Variables
581
October 27, 2016 03:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.