My query looks like below.
select * from table_name
where column_name IN (values)
and trunc(CREATEDATE) > trunc(sysdate) -60
We were able to run this query successfully and extract the data.
But all of sudden the same query we are unable to extract the data into excel sheet with the following error.
‘single-row subquery returns more than one row’
I have tried setting the option database > spool sql > spool sql to file as per one of the forum suggestion but we still getting the same error while extracting the data.
kindly suggest how can we resolve this issue.