Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

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