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: TRIM - When available

Re: TRIM - When available

From: <MarkP28665_at_yahoo.com>
Date: 11 Oct 2002 12:40:52 GMT
Message-ID: <ao6gsk$fmu$1@news.netmar.com>


In article <ao3v0e$bio$2_at_reader1.panix.com>, R Chin <rchin_at_panix.com> writes:
>which version was TRIM first available ?
>thanks
>
>

The ANSI standard trim function was first available with version 8.1. Previous to that you used rtrim and ltrim to trim from the right and left sides of the variable. See the SQL Manual chapter on single row functions for more information.

HTH -- Mark D Powell --

Received on Fri Oct 11 2002 - 07:40:52 CDT

Original text of this message

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