sql - Oracle - single-row subquery returns more than one row , Need to fetch all the rows -

the following query returns

"single-row subquery returns more 1 row"

 select *  sampletable                            status = 'a'               , (select substr(some_code_column, 1, 4) sampletable) = 9999

i need fetch rows of table status , rows substr(some_code_column, 1, 4) = 9999 how change query fetches required result?

no need sub-select, , conditions:

select *  sampletable                            status = 'a'               , substr(some_code_column, 1, 4)  = 9999

EEE