ORA-01427:single-row subquery returns more than one row

Question

I wrote in PL/SQL Developer:

select * from lc_history2

and I got that error:

ORA-01427: single-row subquery returns more than one row

Can someone help? It's necessary.

Answer 1

Without further information, I can only guess that lc_history2 is a view that somehow looks like

 select 
   c,o,l,u,m,n,s
 from
   table where
     some_column = (select another_column 
              from table
             where something = 'SOMEVALUE')

and the inner select returns more than one record for something = 'SOMEVALUE'