Query to Fetch Employee’s Legal Employer SELECT papf.person_number, hauft.NAME LegalEmployer FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft, per_all_assignments_m paam, per_all_people_f papf WHERE haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID…
Read MoreA SQL injection vulnerability has been found in the Progress MOVEit Transfer web application and has been assigned CVE-2023-34362 (also known as MOVEit Transfer Critical SQL Injection Vulnerability). Fastly has…
Read MoreSynthetic response in Fastly is a very fast and useful way to deliver static content on a webpage. This is useful for sitemaps, robots.txt and ssl verification files. 1. Instructions…
Read Morewhat is psudocolumn, Rowdepandancy and Norowdepandency in oracle A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you…
Read MoreProblem: After patching an Oracle 19.8 GRID_HOME on Oracle Restart setup with 19.20 RU patch [35319490], I was not able to start up Oracle Restart HAS due to mentioned error.…
Read MoreIn this case how to open your standby database in read/write mode when you don’t have any access (Lost) on Primary database. NOTE: Currently both Primary and Standby database are…
Read MoreIntroduction: In today’s dynamic IT landscape, ensuring seamless access to critical applications is paramount. This guide outlines the strategic steps to deploy a robust high-availability architecture using a two-node TOMCAT…
Read MoreWhat is log shipping? SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases…
Read MoreINSTANCE API Oracle REST Data Services (ORDS) offers a powerful solution for managing connection pools, enabling efficient communication between applications and databases. The Instance API, introduced in ORDS 20.4, revolutionizes…
Read MoreWhat is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance issues. OSWbb operates as…
Read More