OraFAQ Forum: SQL & PL/SQL » Want to TAB space in between DBMS

Home » SQL & PL/SQL » SQL & PL/SQL » Want to TAB space in between DBMS_OUTPUT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Want to TAB space in between DBMS_OUTPUT [message #171816]

Thu, 11 May 2006 10:36

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Hello

I want to give TAB space in between DBS_OUTPUT.

example

dbms_output.put_line('Completed the old stored proc' ||'TAB SPACE HERE'|| 'rest of sting ');

Thanks

Report message to a moderator

Re: Want to TAB space in between DBMS_OUTPUT [message #171820 is a reply to message #171816]

Thu, 11 May 2006 10:48

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

You want CHR(9).
Try

SQL> SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED
SQL> EXEC DBMS_OUTPUT.PUT_LINE('Completed the old stored proc' || CHR(9) || 'rest of string.');
Completed the old stored proc   rest of string.
 
PL/SQL procedure successfully completed.
 
SQL>

Report message to a moderator

Re: Want to TAB space in between DBMS_OUTPUT [message #171821 is a reply to message #171816]

Thu, 11 May 2006 10:55

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

whats wrong with this??
dbms_output.put_line('Completed the old stored proc' ||' '|| 'rest of sting ');

Report message to a moderator

Re: Want to TAB space in between DBMS_OUTPUT [message #171824 is a reply to message #171821]

Thu, 11 May 2006 11:07

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Thanks Art

It worked with chr(9)

Yasir i want to give a exact tab space between the output
because the output has some meaningful data.

Thanks

[Updated on: Thu, 11 May 2006 11:07]

Report message to a moderator

Exact Spacing [message #171852 is a reply to message #171816]

Thu, 11 May 2006 15:39

rare
Messages: 6
Registered: May 2006
Location: Minneapolis, MN

Junior Member

If you're concerned with spacing, you might want to look up the LPAD and RPAD functions. The TAB character can be interpretted differently depending on what's viewing it.

Report message to a moderator

Re: Exact Spacing [message #171877 is a reply to message #171852]

Fri, 12 May 2006 00:29

Frank
Messages: 7901
Registered: March 2000

Senior Member

What is so strange about wanting a tab-character? Never heard of tab-delimited files instead of comma-delimited?

Report message to a moderator

Erm [message #171879 is a reply to message #171816]

Fri, 12 May 2006 00:42

rare
Messages: 6
Registered: May 2006
Location: Minneapolis, MN

Junior Member

My apologies for trying to be helpful. Your question made it sound like you were formatting output for the screen and didn't mention spooling it to a file.

In your vein, have you ever heard of fixed-width files as opposed to CSV or tab delimited files?

Report message to a moderator

Previous Topic:	Computing average for the time
Next Topic:	ODBC opning error in crystal report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 17 16:29:13 CDT 2025