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