dbms_output.put_line print tabs PL/SQL

a newbie question

how do i print tabs while using dbms_output.put_line so that output can be tab delimited something like this:

title      price
title a   2.00
title b   3.00
blizz_ardAsked:
Who is Participating?
 
seazodiacConnect With a Mentor Commented:
try this:

select  title||chr(9)||price as "title      price"  from <table_name>;
0
 
KongCommented:
seazodiac is right, chr(9) is the TAB character, use in dbms_output as follows:

set serveroutput on
begin
   dbms_output.put_line ('a' || chr(9) || 'b');
end;
/
0
 
blizz_ardAuthor Commented:
both answers are right. thanks very much, i'll award the pts to seazodiac since it arrived first. thanks again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.