By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (
value VARCHAR2(10)
);
INSERT INTO table_name ( value )
VALUES ( UNISTR( '\2600\2601\2602\2603\2604\2605\2606\2607\2608' ) );
ORA-12899: value too large for column "FIDDLE_FWDXSCWVQCKHYJZQSKXN"."TABLE_NAME"."VALUE" (actual: 27, maximum: 10)
DROP TABLE table_name;
CREATE TABLE table_name (
value VARCHAR2(9 CHAR)
);
INSERT INTO table_name ( value )
VALUES ( UNISTR( '\2600\2601\2602\2603\2604\2605\2606\2607\2608' ) );
1 rows affected