You brother help solve the doubts, the problem is as follows:
Select
*
The from
Fstaid_paramword_relation t
Where t.p aram_id in (
- '121', '122', '123');
(select listagg (" ', '| | p. aram_id | |' ' ' ', ', ')
Within group (order by p. aram_id) as param_id
The from Fstaid_Interface_Detail b where p. arent_param_id='120')
);


In the subquery results for the annotation of '121', '122', '123',
Use the subquery is the query result is empty, use annotations to normal query results

CodePudding user response:

Using annotations in the query result:


Use the subquery results: