{"id":3710,"date":"2019-05-18T16:47:11","date_gmt":"2019-05-18T16:47:11","guid":{"rendered":"https:\/\/vinish.dev\/?p=3710"},"modified":"2025-04-16T19:49:11","modified_gmt":"2025-04-16T14:19:11","slug":"oracle-apex-pl-sql-expression-example","status":"publish","type":"post","link":"https:\/\/vinish.dev\/oracle-apex-pl-sql-expression-example","title":{"rendered":"Oracle Apex PL\/SQL Expression Example"},"content":{"rendered":"

In this post, I am giving the Oracle Apex PL\/SQL expression example to validate a text field<\/a>. Not only for validation, but you can also use the PL\/SQL expressions for more purposes in Oracle Apex.<\/p>\n

Oracle Apex PL\/SQL Expression Example<\/h2>\n

In the below example, it is creating validation for the SAL<\/code> column, which must be greater than 1000.<\/p>\n

To create the PL\/SQL expression for the SAL<\/code> column, select the SAL<\/code> field in the content body region and do the right click on it and select Create Validation<\/strong> option.<\/p>\n

In the Validation section, select the type as PL\/SQL Expression<\/strong> and then in the text area enter :sal > 1000<\/code> as shown in the below image:<\/p>\n

\"Oracle
Illustrating PL\/SQL expression to validate a text field in Oracle Apex. Image by FoxInfotech.<\/figcaption><\/figure>\n

Now if the condition evaluates to TRUE, means the SAL is > 1000<\/code> then it is OK; else it will raise the error.<\/p>\n

Oracle Apex PL\/SQL Function Body (Returning boolean) Example<\/h2>\n

You can write the above condition for type PL\/SQL Function Body (returning boolean)<\/strong> as well. To write the validation as demonstrated above, enter the following code into the text area, as shown below:<\/p>\n

Begin\r\n  if :sal > 1000 then\r\n     return true;\r\n  else\r\n     return false;\r\n  end if;\r\nend;<\/pre>\n
See also:<\/h3>\n