/******************************************************************************** *PURPOSE: To delete concurrent program definition and executable from back-end * *AUTHOR: Shailender Thallam * *********************************************************************************/ SET SERVEROUTPUT ON; DECLARE l_prog_short_name VARCHAR2 (240);… Read More »Script to Delete Concurrent Program and Executable from backend
/********************************************************* *PURPOSE: Query to list all DB Links in a database * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT obj.object_type "Object Type", obj.owner "Object Owner", obj.object_name… Read More »SQL Query to list all DB Links in a database
We can use oracle standard REGEXP_LIKE command to apply a regular expression on value. Below is sample query to find if a value is String… Read More »Oracle SQL Regular Expression to find if a Value is String or Number
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to find Customer, Customer Account and Customer Sites Information
Here is a query to extract complete AR Invoice information Note: Set org context before running this query — EXECUTE mo_global.set_policy_context(’S’,81); —- execute mo_global.set_policy_context(‘S’,81); –… Read More »SQL Query to extract complete AR Invoice Information
Deloitte is looking for experience resources in Oracle EBS , JDE, PeopleSoft and Tririga at Hyderabad/Delhi/Bangalore/Mumbai locations of below experience range: EBS – 1 –… Read More »Huge Recruitment at Deloitte for Oracle EBS , JDE, PeopleSoft and Tririga
Click on the question to see the answer Basic SQL Interview Questions Can we use a WHERE clause in TRUNCATE statement? What is the difference… Read More »Top SQL Interview Questions with Answers
Like any other data type in oracle, even DATE data type has a length restriction. A Date data type can hold a maximum data of… Read More »Date Range in Oracle – Minimum Possible Date and Maximum Possible Date
CST_ITEM_COSTS stores item cost control information by cost type. For standard costing organizations, the item cost control information for the Frozen cost type is created… Read More »SQL Script to find Item Cost
/********************************************************* *PURPOSE: Sample Usage of PL/SQL Collections * *AUTHOR: Shailender Thallam * **********************************************************/ SET serveroutput ON; DECLARE ——————– –Record type object ——————– TYPE emp_type IS… Read More »Usage of PL/SQL Collections