Your email is one of the most important online assets that you have. Nowadays, you use email for everything, credit card statements, bank statements, etc. It contains a lot of personal and important information. So, how to safeguard your email Account from Hackers? Hackers are in search of information they could exploit to get some …
How to enable and disable 2-Step Verification for Google Account Read More »
DBMS_UTILITY is utility package in Oracle which provides sub-programs to analyze table, format stack, get CPU time, table to comma and comma to table conversion. Let’s check GET_TIME sub-program which returns the time in millisecond. DBMS_UTILITY.GET_TIME Oracle dbms_utility.get_time returns current time in millisecond. Divide it by 100 to get time in seconds. This API is helpful …
DBMS_UTILITY.GET_TIME – Oracle Database API to Calculate Elapsed Time Read More »
Let’s see how to design concurrent program which spawns multiple child concurrent programs. The master program waits till all child programs are complete.Oracle provides built-in package FND_CONC_GLOBAL and FND_REQUEST to achieve parent-child program using PL/SQL. FND_CONC_GLOBAL.SET_REQ_GLOBALS – sets the value of the REQUEST_DATA global variable. conc_status – Status of concurrent program like ‘PAUSED’, ‘RUNNING’ request_data …
Master-Child Concurrent Program Using FND_CONC_GLOBAL in Oracle Apps Read More »
