db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Looking for Debry SQL equivalent of REPLACE, TRANSLATE, etc.
Date Mon, 04 May 2009 01:03:26 GMT
Ferenc <ferenc@seemoredata.com> writes:

> Hi 
>
> I am new to Derby but a veteran with Oracle and Sql Server.
>
> reading the reference guide for 10.4, I can't find references to:
> - REPLACE
> - TRANSLATE
> - MonthName or something like the Sql Server DatePart or Oracle TO_CHAR
> functions
> - LPAD, RPAD
> - INITCAP
>
> We can create called formatting functions that we can apply to the data once
> it is returned from the DB, but I would prefer to let the DB do this kind of
> work.

You could use Derby stored functions to have such work done in the database
rather than in the app, cf.

http://db.apache.org/derby/docs/10.4/ref/rrefcreatefunctionstatement.html

>
> Also, I notice there is the generic CASE statement, but no clear indication
> of something like
>  CASE {expression) when Value 1 then .... when Value2 ... else ..... end
> Is this type of CASe statement supported?

Is this what you need? It seems to cover your case..

http://db.apache.org/derby/docs/10.4/ref/rrefcase.html

Hope this helps,
Dag

Mime
View raw message