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

end;

begin

first_number .- al ;

second_number .- a2 ;

--- dbms statement will be used to display the values derived.

--- Always convert the date, number into char type before

--- display.

dbms_output.put_line(first_number 11','11 second_number);

--- calling the procedure and while calling values are

passed

--- as parameters. swaps(first_number,second_number);

dbms_output.put_line(first_number 11','11

second_number);

end;

end;

Using while …  loop  and  end loop procedure has been created to

reverse the string given at the beginning.

NEED: I want to reverse the given string such as

"RAGHUNATHAN" as "nahtanuhgar" using PL/SQL Block

Declare

given_string varchar2(50) := 'RAGHUNATHAN' ;

repeat_loop_count number;