Re: HELP!!! sql select command output

Article View: alt.comp.databases

Article #85

Back to alt.comp.databases Previous Next

#85

From: Sang Ryung Lee
Date: Thu, 25 Mar 1999 00:00

8 lines
1552 bytes

Before you query, you set the column foramt.

SQL> col  f_docnumber  format  9999999999
SQL> select  f_docnumber  from  doctaba

I hope it may helps you.

 S.R. Lee

Technical Details

Message-ID: <36F999BC.2DCA17FA@shinsegi.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7dbqr5$2nm$1@news-1.news.gte.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 122e4d,cfaa4b53dc1c492c
X-Google-Attributes: gid122e4d,public
X-Google-Thread: 104de1,cfaa4b53dc1c492c
X-Google-Attributes: gid104de1,public
X-Google-Thread: fa4f9,cfaa4b53dc1c492c
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: fc5c9,cfaa4b53dc1c492c
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: f99a8,cfaa4b53dc1c492c
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 11355a,cfaa4b53dc1c492c
X-Google-Attributes: gid11355a,public
X-Google-Thread: 10a90d,cfaa4b53dc1c492c
X-Google-Attributes: gid10a90d,public
X-Google-Thread: fdf39,cfaa4b53dc1c492c
X-Google-Attributes: gidfdf39,public
From: Sang Ryung Lee <srlee@shinsegi.com>
Subject: Re: HELP!!! sql select command output
Date: 1999/03/25
Message-ID: <36F999BC.2DCA17FA@shinsegi.com>
X-Deja-AN: 458756379
Content-Transfer-Encoding: 7bit
References: <7dbqr5$2nm$1@news-1.news.gte.net>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Trace: news.nuri.net 922327850 20586 203.226.204.161 (25 Mar 1999 02:10:50 GMT)
Organization: Inet Internet Services
Mime-Version: 1.0
NNTP-Posting-Date: 25 Mar 1999 02:10:50 GMT
Newsgroups: alt.comp.databases,bit.listserv.sqlinfo,comp.database,comp.databases,comp.databases.ms-sqlserver,comp.databases.oracle.misc,comp.databases.oracle.server,ncr.databases.oracle

Reply to Parent Message