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

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