Solved

dbms_output.put_line print tabs PL/SQL

Posted on 2003-11-04
3
7,912 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:blizz_ard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 23

Accepted Solution

by:
seazodiac earned 20 total points
ID: 9683714
try this:

select  title||chr(9)||price as "title      price"  from <table_name>;
0
 
LVL 2

Expert Comment

by:Kong
ID: 9683933
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
 

Author Comment

by:blizz_ard
ID: 9684073
both answers are right. thanks very much, i'll award the pts to seazodiac since it arrived first. thanks again
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query for highest sequence 4 75
date show only hh:mm 2 50
Oracle Nested table uses ? 2 60
Need to Implment Subset of Oracle Schema to Read-Only version 7 37
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question