var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: single row subquery returns more than one row
i have a problem here and i cant seem to solve it
have attached the data and the code ive used
pls help !
Why did you complicate basically simple query? I'd say you don't need all those subselects, as the whole thing could be done easier, such as
MINUS (in your original query) means that some data already exists in the target table? If it is empty, you don't need that.
insert into trap_ra_k2_ain_balance
(date_loaded, week_no, reload_date, msisdn,
(select date_loaded, week_no, reload_date, msisdn,
to_number(substr(new_balance , instr(new_balance , '=') + 1)) / 100,
to_number(substr(reload_amount, instr(reload_amount, '=') + 1)) / 100
thanks little foot
its working fine and yes minus exactly does what you say