Dynamic Visual Attribute

1. Overview This blog explains about, How to Set Current Record Color -Multi Color. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle FORMS [...]

Email Checking Validation function

1. Overview This blog explains about, how we can Email validation using PLSQL function. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle PLSQL [...]

How to Hide Password in Oracle Forms

1. Overview This blog explains about, how we can hide Password in oracle FORMS. In Oracle Forms, if you are creating any custom login screen or giving any password security option, then there is [...]

PANCARD Validation – PL/SQL Function

1.          Overview When we give PANcard, We are returning PANcard is valid or not. 2.          Technologies and Tools Used The following technology has been used to achieve the expected output. [...]

Dynamic List of values (LOV)

1.Overview LOVs can be displayed by end user request (when an LOV is available), Most of the user does not know the item have LOV option.  For this we add a Push button next to LOV item, user [...]

Creating Excel File in Oracle Forms

Below is the example to create an excel file in Oracle Forms. Pass the Sql query string to the below procedure to generate an Excel file using Ole2 package. Sample Code: [...]

Using Post_Query Trigger in Oracle Forms

Introduction When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for each record placed on the block’s [...]

How To PLAY_SOUND in Oracle Forms

Introduction Play sound is used to play audio files in Oracle Forms, Play Sound plays the sound object in the specified sound item PLAY_SOUND examples The following plsql block you can write in [...]

Start typing and press Enter to search