Oracle Apps Technical Stuff
Friday, September 21, 2012
How to Query on the LONG datatype Columns
›
-- Create the custom table as mentioned below CREATE TABLE XX_ALL_TRIGGERS AS SELECT TRIGGER_NAME,TO_LOB(TRIGGER_BODY) AS TRIGGER_BODY F...
Wednesday, August 29, 2012
Query to get the Details of the WF Service Components
›
1. Go To responsibility Workflow Administrator 2. Navigation Workflow Administrator --> Oracle Application Manager -...
Thursday, August 23, 2012
Script To Check the File On Database Server(Unix) Using UTL_FILE
›
Below Script is used to verify the file exists on the Server using PLSQL UTL_FILE functionality. DECLARE l_fexists BOOLEAN; ...
Application object Library Queries
›
1. Query To get list of responsibilities. ======================================================================== SELECT (SELECT applic...
‹
Home
View web version
