DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: How do I print space in the beginning of a line

Threaded View

  1. #4
    Join Date
    May 2002
    Posts
    2,645
    You can use this to get characters from dual. Change the start and end points of the loop so you don't get overflow.

    set serveroutput on
    declare
    str varchar2(20);
    begin
    for i in 1..60 loop
    select 'aaaa'||chr(i)||'aaaa' into str from dual;
    dbms_output.put_line(i||', '||str);
    end loop;
    end;

    When you hit chr(32), you will see a space. Plus, it shows the other commonly used chr(x) values and what they do for you.
    Last edited by stecal; 10-07-2003 at 06:23 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width