Monday, 9 June 2014

How to get back the sequence in plsql block



begin
EXECUTE IMMEDIATE 'alter sequence ' || p_name || ' increment by ' || (p_val - l_num - 1) || ' minvalue 0'

end;

Sunday, 1 June 2014

Report Mismatching Values while displaying

I have created table and created rdf report which is working fine
Later i have changed the table structure ,but the data displaying in the previous order only .
May be its silly thing but it has taken 2 hours for researching this...




Before table Structure  change output.

After table structure change output .
If you compare sub inv and locator then see the change.