On Wed, Dec 06, 2017 at 04:53:36PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:34:17 +0000, Tim Bunce <tim.bu...@pobox.com> > wrote: > > > A view might be useful. Or perhaps define your own function to wrap the > > expression. > > That worked very well! > > CREATE OR REPLACE FUNCTION diac_u (v VARCHAR2) RETURN NCHAR IS > BEGIN > RETURN utl_i18n.raw_to_nchar (utl_i18n.string_to_raw (v), 'utf8'); > END; > / > > select diac_u (land_u) from land where c_land = 7072;
You might want to add DETERMINISTIC before the IS so the function can be used more efficiently in some cases. Tim.