![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
In the ledger_master , number of rows is stored whereas 'BS',
'PL' two sets of values alone repetitively stored in Report type column. We like to select the unique records and do the previous exercise of reversing the content. In this case, pick out two values alone as 'BS',
'PL' from the entire table and reverse the contents as 'SB', 'LP'.
NEED: I want to select all the distinct unique records of account type from account_head_master and reverse the values and display
declare
given_string varchar2(50); repeat_loop_count number; result varchar2(50);
cursor cursorl is select distinct account_type from account_head_master
order by account_type;
cursor_val cursorl%ROWTYPE;
begin
open cursorl;
loop