Print_line user defined function will help you to print the line which is more than 255 bytes.
create procedure print_line (
                 string_in IN VARCHAR2,
                 split_in  IN PLS_INTEGER DEFAULT 255
                 ) as
begin
   for i in 1 .. ceil(length(string_in)/split_in) loop
      dbms_output.put_line(substr(string_in,split_in*(i-1)+1,split_in));
   end loop;
end;
/
create or replace public synonym put_line for put_line;
grant execute on put_line to public;
Subscribe to:
Post Comments (Atom)
External Table
Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...
- 
Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...
 - 
DECLARE TYPE emp_ref_cursor IS REF CURSOR; TYPE empno_tab IS TABLE OF NUMBER; TYPE ename_tab IS TABLE OF VARCHAR2(50); v_emp_...
 - 
Cursor for loop simplifies the PL/SQL program where PL/SQL itself take care most of the things which includes cursor steps and variab...
 
No comments:
Post a Comment