Print Preview Region into PDF Plugin in Oracle APEX

Print Preview Region into PDF Plugin in Oracle APEX This plugin is updated version 2.0 of old plugin v1.0 which converts your APEX region data or report data into pdf format. Now the change is it will also support open print preview and APEX chart instead of download. For better understanding please look at the …

Use of $s $x $v

$x $x is used to find the control on the DOM meaning looking for any item available on DOM. If the control is found then it returns the dom of the Item else false. Syntax: $x('PAGE_ITEM'); $v $v is used to get the value from the item. Syntax: $v('PAGE_ITEM'); $s $s is used to set the values in Item. \ …

Ref cursor switch based on condition

A ref cursor is a datatype that holds a cursor value in the same way that a varchar2 variable will hold a string value. Ref cursor will allow us to open difference sets of query where is the explicit cursor will not allow us to open a query other then the one which is associated to that cursor pointer. Using ref …