To calculate the distance in meters between two points using their latitude and longitude in Oracle, you can use the Haversine formula with Earth’s radius set to 6,371,000 meters (6,371 km) . 1. Using the Haversine Formula in SQL SELECT 6371000 *…
-- scheduling at 01:00 am declare jobno number; begin dbms_job.submit(jobno, '<procedurename>;',TRUNC(sysdate)+1/24,'TRUNC(sysdate+1)+1/24'); end; -- every 2 hours declare jobno number; begin dbms_job.submit(jobno, …
In Oracle, to kill sniped sessions dynamically using SQL, you can use EXECUTE IMMEDIATE inside a PL/SQL block. Understanding Sniped Sessions A sniped session is a session that has been marked as inactive (due to profile settings like IDLE_TIME in …
To view current database parameters in Oracle, you can use the following methods: 🔹 1️⃣ View All Parameters Using V$PARAMETER Run the following SQL query to see all current database parameters : SELECT name, value FROM v$ parameter ORDER BY na…
ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00216: invalid character 231 (0xE7) Error at line 3108 The ORA-31011: XML parsing failed error, along with LPX-00216: invalid character 231 (0xE7) , indicates that Oracle…
🔹 Masking a Mobile Number in Oracle Masking a mobile number means partially hiding digits for privacy while displaying only a few visible characters. Below are different ways to achieve this in Oracle. ✅ 1️⃣ Mask Middle Digits (Show First & Last …
🔹 Generating a Random Password in Oracle (with at least one special character) To generate a random password in Oracle that meets the following criteria: ✅ At least one special character ✅ Contains uppercase, lowercase, numbers ✅ Has a specific lengt…
Calculating the Number of Days in a Year in Oracle In Oracle, the number of days in a year can vary depending on whether it's a leap year (366 days) or a non-leap year (365 days) . Below are different ways to determine this: ✅ 1️⃣ Basic Calculat…
Calculating Age in Years and Months in Oracle To calculate age in years and months from a given date (e.g., date of birth), you can use the MONTHS_BETWEEN function. ✅ 1️⃣ Get Age in Years and Months SELECT TRUNC(MONTHS_BETWEEN(SYSDATE, DATE &…
MONTHS_BETWEEN Function in Oracle The MONTHS_BETWEEN function in Oracle calculates the number of months between two dates. ✅ Syntax MONTHS_BETWEEN(date1, date2) date1 – The later date. date2 – The earlier date. Returns a decimal number (fraction…
