hi is it posible to create a stored procedure that have a subquery and a union statement
i have a query like this that i want to convert it in a stored procedure so i can get the values that return the query in a arraylist in spring mvc
i 'm talking about a query like this:
select a,b,c,d
from table1, table2
where
a=b ...
and not exists (
select
null
from
..
where
.....
)
union
SELECT ....
from
....
where
...
