在APEX中的现有字段上查询第二条验证语句 [英] Querying for 2nd validation statement on an existing field in APEX

问题描述

where id = (select id from tab1 where col2 = 'range') and desc = 'min'; 

var max := select LV R from LV 
where id = (select id from tab1 where col2 = 'range') and desc = 'max';

begin if :P1_range < min or :P1_range > max then 'invalid range' 
end if; 
end;

上面的^将是我的第二个验证语句.我有一个验证语句，该字段中必须有一个值.

the above ^ will be my 2nd validation statement. i have one validation statement in place that the field must have a value in it.

推荐答案

使用验证时，确切的语法取决于您选择的类型.使用内联帮助确保您匹配表达式格式.

When using validations, the exact syntax will depend on the Type you've selected. Use the inline help to ensure you match expression format.

还要确保您明确地转换数字和日期，因为会话状态存储为字符串.

Also make sure you explicitly convert and numbers and dates, since sessions state is stored as a string.

如果您收到任何错误，最好在这里进行描述，因为这样可以更快地解决问题.

If you receive any errors, it's best to describe them here, as they will allow for quicker resolution.

这篇关于在APEX中的现有字段上查询第二条验证语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！