fetch cursorl into cursor_val;
exit when cursorl%NOTFOUND; given_string := cursor_val.account_type; repeat_loop_count := length(given_string); while repeat_loop_count > 0
loop
result := result II substr(given_string,repeat_loop_count,l);
repeat_loop_count := repeat_loop_count - l ;
end loop; dbms_output.put_line(result); result := null;
end loop;
close cursorl;
end;
OUTPUT/RESULT: LATIPAC
EUNEVER
Statement processed.
NEED: I want to know under what statement the account heads are accounted. For example capital account is accounted in balance sheet and sales account is accounted in profit and loss account etc. Use CASE statement to determine the results declare