Showing posts from February, 2025
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…
🔹 Why Are SNIPED Sessions Not Getting Cleared in Oracle? SNIPED sessions in Oracle are inactive sessions that the database marked for termination but are not fully cleared . These sessions typically remain in the V$SESSION view with a SNIPED stat…
