Create temporary database CREATE GLOBAL TEMPORARY TABLE SELECTED_NUMBERS ( bnumber varchar2(50) not null) on commit delete rows; PRESERVE