Re: help with SQL*Plus

A copy of this was sent to Rob Mason <rmason_at_cellularsouth.net> (if that email address didn't require changing) On Fri, 04 Sep 1998 08:16:01 -0500, you wrote:

>I have a table that has an ID in multiple columns and the description of
>those ID's in another table. What is the best method (using SQL*Plus)
>that will allow me to display the text description on the same line with
>other text descriptions of ID's in the same row?
>

read the sqlplus manual and check out the COLUMN command for formatting.

For exmaple:

SQL> set linesize 100
SQL> column id format 999
SQL> column descr format a20 word_wrapped

and so on. You can use these commands to make each column come out formatted in the way you want.

>For example:
>
>select txt.descr, txt.descr
>from mydescr txt, myid id
>where id.idcolumn1=txt.id
>or id.idcolumn2=txt.id;
>
>
>mydescr
>---------
>1 Description 1
>2 Description 2
>3 Description 3
>
>myid
>---------------
>1
>2
>3
>
>Does this make sense?
>
>Thanks in advance for any help
>
>Rob Mason
>rmasonjr_at_cellularsouth.com
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.