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

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

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  an 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;