Specifies the literal character set for the module or interactive
SQL session.
1 – 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)0[m[1;4mSET[m[1m [1;4mLITERAL[m[1m [1;4mCHARACTER[m[1m [1;4mSET[m[1m qq> runtime-options qqqq> [m [1m [m (B)0[m[1mruntime-options [m [1m [m [1mqqwqqq> 'string-literal' qqqqqqwqqqqq> [m [1m tqqq> parameter qqqqqqqqqqqqqu [m [1m mqqq> parameter-marker qqqqqqj [m
3 – Arguments
3.1 – 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.2 – 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.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.
4 – 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