Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

frequently referred condition type  with an example for understanding purposes'

 

 

→      Condition Type : Current Page in Expression 1

 

A user has given set of page numbers comma separated as 4,11,17' The given condition will be processed only when the rendered page numbers falls within the set of given numbers' In other words, page no 4, page no

11, page no 17 alone will evaluate this conditions and rest of the pages will ignore this condition while rendering or processing the pages'

→      CONDITION TYPE : ExISTS

 

Here, generally sql query will be given. For example "select 1 from

 

staff-mst where staff-code = :P1-STAFF-CODE; This querry must return a value otherwise this conditions will not get evaluated'

→      CONDITION TYPE : PLlSQL ExPRSSION

 

Any valid expression supported by PLlSQL can be given for evaluation' For example NVL(:P1-STAFF-BASIC-PAY,0) > 10000; This condition will be evaluated only when the value is more than 10000 and status marked as pass or this conditions determined as failed'