Specifies the identifier character set for the module or
interactive SQL session.
1 – Environment
You can use the SET IDENTIFIER 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;4mIDENTIFIER[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 used for database object names such
as table names and column names. The value of runtime-options
must be a valid character set. See the Oracle Rdb SQL Reference
Manual for a list of allowable character sets and option values.
3.2 – parameter-marker
Specifies the character set used for database object names such
as table names and column names. The value of runtime-options
must be a valid character set. See the Oracle Rdb SQL Reference
Manual for a list of allowable character sets and option values.
3.3 – 'string-literal'
Specifies the character set used for database object names such
as table names and column names. The value of runtime-options
must be a valid character set. See the Oracle Rdb SQL Reference
Manual for a list of allowable character sets and option values.
4 – Example
Example 1: Setting the identifier 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 SHIFT_JIS
Literal character set is SHIFT_JIS
Display character set is SHIFT_JIS
SQL> set identifier 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 SHIFT_JIS
Display character set is SHIFT_JIS