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

Home -> Community -> Usenet -> comp.databases.oracle -> Ordinal Function

Ordinal Function

From: Terry Coccoli <request_at_ifneeded.com>
Date: Tue, 20 Jul 2004 19:33:32 GMT
Message-ID: <gseLc.20093110$Id.3323112@news.easynews.com>


Has anyone created a user function to return the ordinal position based on numeric input?

In other words, f(1) returns 'st', f(2) returns 'nd', f(3) returns 'rd', etc. Received on Tue Jul 20 2004 - 14:33:32 CDT

Original text of this message

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