|
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|