Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: limit characters returned by a select statement

Re: limit characters returned by a select statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 30 Oct 2001 15:30:47 +0100
Message-ID: <tttglle1of6ud8@corp.supernews.com> 






"Dave" <ryzk_at_yahoo.com> wrote in message
news:fb1cbc4b.0110300531.10ff0733_at_posting.google.com...


> is there a way, through sql, to limit the number of characters

> returned by a sql statement for a given column?




Use substr



The exact syntax can be looked up in the Sql reference manual



Regards


--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address


Received on Tue Oct 30 2001 - 08:30:47 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US