Posts by Palanikumar K

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…

Read More

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…

Read More

Creating Object Library OLB in Oracle D2k Form

Step – 1 Create a form in form builder and create objects like Data Block, Canvases, Windows, Program Units etc. as shown in below image. Step – 2 Then Highlight…

Read More

Create a New PL/SQL Library

The steps in this section will show you how to create a new PL/SQL library, then create a function that will live in this library. To create the library: Launch…

Read More

Globalization

Globalization   The following are list of types under Globalization on the Shared Components page. Globalization Attributes Text Messages Translate Application   1.Globalization Attributes We can develop applications that can…

Read More

Application Logic

The application Logic is one of the module in Shared components,It consists of different types of features as below Application Definition Attributes Application Items Application Process Application Computations Application Settings…

Read More

Sending Email Using UTL SMTP

1.   Overview This document talks about the utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments. 2.  Technologies and Tools Used…

Read More

Oracle Apex Custom Tool Tip for Report Columns

1.          Overview This document talks about how to show the custom tooltip in report columns 2.          Technologies and Tools Used The following technology has been used to achieve Custom Notifications…

Read More