1  SET_DEFAULT_CHARACTER_SET
   Specifies the default character set for the SQL session.
 

2  Environment
   You can use the SET DEFAULT 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

 SET DEFAULT CHARACTER SET ---> runtime-options ----->
 



 runtime-options
 
 --+---> 'string-literal' ------+----->
   +---> parameter -------------+
   +---> parameter-marker ------+

 

2  Arguments
 

3  parameter

   Specifies the default character set for your session. The value
   of runtime-options must be a valid character set. For a list of
   allowable character set names and option values, see Oracle Rdb
   SQL Reference Manual.
 

3  parameter-marker

   Specifies the default character set for your session. The value
   of runtime-options must be a valid character set. For a list of
   allowable character set names and option values, see the Oracle
   Rdb SQL Reference Manual.
 

3  'string-literal'

   Specifies the default character set for your session. The value
   of runtime-options must be a valid character set. For a list of
   allowable character set names and option values, see the Oracle
   Rdb SQL Reference Manual.
 

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

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