Introduction In the rapidly evolving world of web development, creating highly performant and user-friendly applications is a top priority. Angular, a powerful and versatile framework maintained by Google, has…
Read MoreIntroduction: A SQL Server Maintenance Plan is an essential strategy for managing and optimizing the performance of your SQL Server databases. These plans are designed to automate routine database management…
Read MoreIntroduction: SQL Server Linked Servers is a feature in Microsoft SQL Server that allows you to connect and execute commands against OLE DB data sources on different servers. This functionality…
Read MoreIntroduction: In this blog, we will explore what Show Plan permission is and how it can help DBAs and developers gain insights into the Estimated and Actual Execution Plans. Show…
Read MoreIntroduction The Query Store is a feature in SQL Server that provides insight into query performance by tracking and storing detailed information about query execution over time. The Query Store…
Read MoreScript to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreMove concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group Step 1) we…
Read MoreOracle EBS – Query to get Purchase Order Details approved based on Hierarchy Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.* FROM (SELECT ou, supplier_number, supplier_name, po_number,…
Read MoreOracle EBS – Query to get Open Purchase Order Details SELECT org_code, org, operating_unit, buyer, supplier, po_number, line_num line_number, item_code item, item_description description, quantity, unit_price price, need_by_date, shipment_line_num, shipment_qty, shipment_needby_date,…
Read MoreExploring the New Features in Oracle 23c: What You Need to Know Oracle’s latest release, Oracle 23c, brings a suite of new features and enhancements designed to improve database management,…
Read More