Re: [q]: How to format a SQL output ?

From: crosby <crosby_at_po.pacific.net.sg>
Date: 1996/11/05
Message-ID: <55n2va$p4v_at_newton.pacific.net.sg>#1/1

Before issuing your SQL statement, enter the following line in SQL*Plus

column name format a20

Now execute the following query

select name
from emp

This will ensure only the first 20 characters are displayed.

Regards

N.Prabhakar
Socgen Crosby Securities, Singapore

email : prabhs_at_pacific.net.sg Received on Tue Nov 05 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Markus Ingendahl: "Oracle ODBC Driver"
Previous message: tomas_at_senna.std.lt: "How to use dbms_job package. Help desperately needed !!!!!!!"
In reply to: Patrício Rodrigues Domingues: "[q]: How to format a SQL output ?"
Next in thread: dan merryman: "Re: Need Help with PL/SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message