ch08_instr_unicode.sql

OReilly Oracle PL SQL Programming第4版源代码

/* These are the four Unicode-related INSTR examples.
   You MUST execute these examples on a system using UTF-8 as
   the database character set and UTF-16 as the national character
   set. Otherwise, your output will not match that shown in the book. */
DECLARE
   --The underlying database datatype for this example is Unicode UTF-8
   x CHAR(30 CHAR) := 'The character