CREATE TABLE source_iot (A NUMBER(10), B CHAR(5), CONSTRAINT PK_source_iot PRIMARY KEY (A)) ORGANIZATION INDEX

CREATE INDEX IX_source_iot ON source_iot (UPPER(B))

CREATE TABLE dest (B CHAR(5))

INSERT INTO dest (B) SELECT /*+ INDEX_FFS(source_iot IX_source_iot) */ UPPER(B) FROM source_iot WHERE UPPER(B) = 'hi'

DROP TABLE source_iot

DROP TABLE dest