To achieve this you need to create a small package and run a query : Package Specification : CREATE OR REPLACE PACKAGE get_user_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2; END get_user_pwd; / Package Body: CREATE OR REPLACE PACKAGE BODY get_user_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE ...
In Oracle, you can create an autonumber field using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.Syntax :The syntax to create a sequence in Oracle:CREATE SEQUENCE Sequence_Name MINVALUE value MAXVALUE value START WITH value INCREMENT BY value CACHE value;Example :CREATE SEQUENCE XX_PO_SEQ MINVALUE 1 START WITH 1 ...
Concurrent Programoracle apps R12
Query to get concurrent program run details in oracle apps
posted on , by Adarsh
SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME, round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time, a.request_id,a.parent_request_id, a.request_date, a.actual_start_date, a.actual_completion_date, (a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end, (a.actual_start_date-a.request_date)*24*60*60 AS lag_time, d.user_name, a.phase_code, a.status_code, a.argument_text, a.priorityFROM apps.fnd_concurrent_requests ...
