Re: TAB in the output of DBMS_output.put_line???

Originally posted by Andre
> Hello all,
>
> I want (using the DBMS_output.put_line) create a table using a oracle
> package.
> So, i need to insert a TAB or something in the
> DBMS_output.put_line-code
>
> Does soemone know??
>
> Regards,
> Andre

The TAB character has ASCII code 9, so CHR(9) can be used:

SQL> exec dbms_output.put_line('a'||chr(9)||'b'||chr(9)||'c') a b c

PL/SQL procedure successfully completed.

Is that what you meant? I can't see the connection to creating a table.

--
Posted via http://dbforums.com