Re: Nested scalar functions in Oracle SQL? (easy)

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Sat, 03 Mar 2001 07:54:13 GMT
Message-ID: <3aa0a322.4678186@news.online.de>

TRIM is invalid, use LTRIM or RTRIM. Otherwise SUBST(SUBSTR('xxxxx',1,4),2,3) works as long as the string lengths are valid.

Hth.

On Thu, 1 Mar 2001 11:50:33 -0500, Steven Healey <sphealey_at_MailAndNews.com> wrote:

>In Oracle SQL (not PL/SQL, just a query design), can I nest calls to scalar
>functions? For example, can I say
> SUBSTR(TRIM(variable),1,5)
> or
> SUBSTR(SUBSTR(variable),1,5),2,4)?
>
>This is possible in every other programming language I have used, but I get
>syntax errors from SQL Plus when I try it.
>
>sPh
>

EMail: knijff_at_bigfoot.com Received on Sat Mar 03 2001 - 01:54:13 CST