plsql - Oracle APEX validate Input during Data Load with Transformation Rule -
in apex , when performing data load (e.g. upload of csv file apex application), possible validate input data using transformation rule? for example, suppose upload data cars have been sold month. target table has column car_manufacturer , num_car_sold. the column car_manufacturer must accept 3 values, ('a1', 'a2', 'a3'). in pseudo plsql , give idea: if :car_manufacturer in ('a1, a2, a3') :car_manufacturer else <error> how can check in upload phase? possible use transformation rule, in order if fails, returns error message? other ways? thanks in advance. you put constraint on table definition per other answer, or if want error message when data load used, can use table lookup. go shared components -> data load definitions open data load definition want edit create table lookup select column (e.g. car_manufacturer) set table lookup attributes table contains list of valid values (you'll need either table or vi...