Friday, February 22, 2019

ename already exitst validation in Oracle Apex

1. ename already exitst

1. Base on emp table in scott
2. cerate validation
3. go to property validation type: No Rows returned
4. Sql Query :  select ename from emp1 where ename=:P58_Ename;
5. Error Message : empname already exist

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/