Saturday, 11 August 2018

Oracle / PLSQL: FOR LOOP IN REVERSE

SET SERVEROUTPUT ON:

Declare
b2 varchar2(100);
Begin
select count(*) into b2 from countries;
for i in reverse 1..b2 loop
dbms_output.put_line('Reverse Value is: '|| i);
end loop;
end;
/

No comments:

Post a Comment

AWS Migration Guide: Complete Cloud Migration Strategy for Businesses

Amazon S3 Complete Guide

Amazon S3 Complete Guide: Everything You Need to Know About AWS Simple Storage Service Amazon S3 Complete Guide: Eve...