I have 2 complex queries that each bring one result each.
I.e.
Select C1 INTO V1 from complex_query1;
Select C2 INTO V2 from complex_query2;
Is there any advantage in doing this
SELECT
(Select C1 from complex_query1), (Select C2 from complex_query2)
INTO
v1, v2
FROM dual;
Over 2 separate calls??