Creating UNDO Functionality in Oracle Forms

 Retrieving data from the database and changing the data is really easy. But what, if the user changes data and want to do an UNDO?Doing a new query is the easiest way. The limitations are:- in a multi-record-block...

Read More

Oracle Forms: Word / Excel using Client OLE2

 Package specification:PACKAGE excel IS /* Global excel.Application Object --> this represent excel Object. */ appl_id client_ole2.obj_type; /* Open file that act as template....

Read More

Function to find years month days hours mins sec from date

CREATE OR REPLACE FUNCTION GET_RRRRMMDDHHMI(P_DATE1 DATE, ---FROM DATE                                           ...

Read More

TRANSLATOR - Encryption Decryption Package for Oracle DB

TRANSLATOR - Encryption Decryption Package for Oracle DBIn cryptography, encryption is the process of transforming information (referred to as plain-text) using an algorithm (called cipher) to make it unreadable to anyone...

Read More

Oracle Reports: Generate output into Spreadsheet Excel Format

 Most end-users use Excel as a very generic tool, because of their familiarity and the control in analysing data using the power of MS Excel.Customers request converting lot of reports to excel.As you can imagine, converting...

Read More

Oracle SQL: Generating Dates in Sequence & Time in Sequence

 To achieve our task we use connect by level in our SQL to generate the followings:SQL for Generating Dates in Sequence:Select To_Date(Sysdate-30, 'dd-mm-rrrr') + (Level - 1) DatesFrom DualConnect By Level <= ((To_Date(Sysdate,...

Read More

Exporting a database does not export empty tables

ProblemWhen using the exp utility to export an Oracle database, you may find that not all tables are included in the export.CauseEmpty tables may not be included in the export, as they have not been allocated space on disk....

Read More

Place the stacked canvas in TAB page canvas

The stacked canvas cannot be placed in the TAB page canvas. However, the stacked canvas may be shown on all/required tab pages.Example: (Requirement such as this...) we must display the ITEM DETAILS (Line sequence number,...

Read More

How to enable/disable case sensitive passwords in Oracle11g?

Case-sensitive passwords are a new security feature introduced in Oracle 10g, however this feature is enabled by default in Oracle 11g.If you utilise an older version of Oracle Forms (6i in my instance) with an Oracle 11g...

Read More