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

Home -> Community -> Usenet -> c.d.o.tools -> Nested scalar functions in Oracle SQL? (easy)

Nested scalar functions in Oracle SQL? (easy)

From: Steven Healey <sphealey_at_MailAndNews.com>
Date: Thu, 1 Mar 2001 11:50:33 -0500
Message-ID: <3AA09A42@MailAndNews.com> 






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
Received on Thu Mar 01 2001 - 10:50:33 CST












Original text of this message













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