1  SET_LITERAL_CHARACTER_SET
   Specifies the literal character set for the module or interactive
   SQL session.
 

2  Environment
   You can use the SET LITERAL CHARACTER SET statement:

   o  In interactive SQL

   o  Embedded in host language programs to be precompiled

   o  As part of a procedure in an SQL module

   o  In dynamic SQL as a statement to be dynamically executed
 

2  Format

 (B)0SET LITERAL CHARACTER SET qq> runtime-options qqqq>    
                                                        



 (B)0runtime-options                        
                                        
 qqwqqq> 'string-literal' qqqqqqwqqqqq> 
   tqqq> parameter qqqqqqqqqqqqqu       
   mqqq> parameter-marker qqqqqqj       

 

2  Arguments
 

3  parameter

   Specifies the character set for literals that are not qualified
   by a character set or national character set. The value of
   runtime-options must be a valid character set. See the Oracle
   Rdb SQL Reference Manual for a list of the allowable character
   sets and option values.
 

3  parameter-marker

   Specifies the character set for literals that are not qualified
   by a character set or national character set. The value of
   runtime-options must be a valid character set. See the Oracle
   Rdb SQL Reference Manual for a list of the allowable character
   sets and option values.
 

3  'string-literal'

   Specifies the character set for literals that are not qualified
   by a character set or national character set. The value of
   runtime-options must be a valid character set. See the Oracle
   Rdb SQL Reference Manual for a list of the allowable character
   sets and option values.
 

2  Example
   Example 1: Setting the literal character set of an interactive
   session

   SQL> show character sets;
   Default character set is DEC_KANJI
   National character set is DEC_KANJI
   Identifier character set is DEC_KANJI
   Literal character set is SHIFT_JIS
   Display character set is SHIFT_JIS
   SQL> set literal character set 'DEC_KANJI';
   SQL> show character sets;
   Default character set is DEC_KANJI
   National character set is DEC_KANJI
   Identifier character set is DEC_KANJI
   Literal character set is DEC_KANJI
   Display character set is SHIFT_JIS