SQL Server - How to Delete Duplicate Data?
Following the Sql Query below: WITH DuplicateRows AS ( SELECT *, ROW_NUMBER() OVER…
Read more
View allHow to check the index(es) in a table in a database?
Lvea Aem Technologies
Use the queries below to show the index of your table: For MySQL or MariaDB: SQL: SH…
How to Find Your Windows PC's Serial Number by Command?
Lvea Aem Technologies
Tree Step to get serial number pc with the wmic bios get serialnumber command: Ex: Serial…
The FLEXCUBE Core Banking System Upgrade Version 14.7 project
Lvea Aem Technologies
Certainly! Here is a detailed breakdown of the agenda for the kick-off meeting of the FLEXCUBE Cor…
Oracle Query to remove all Numeric, Characters ... from the text
Lvea Aem Technologies
Bellow we will use the REPLACE Function to remove all Numeric, Characters or Special characters fr…
How To Create a Free WordPress Website with Free Hosting & Domain
Lvea Aem Technologies
Step 1: To install the WordPress software for free, you need to “ sign up on InfinityFree ” and “…
Step by Step to Make Report Using Oracle/SQL Query with Oracle BI Publisher (OBIEE)
Lvea Aem Technologies
The 4 Steps to building reports using Oracle BI Publisher with SQL or Oracle Query. Step 1: Writin…
How to extract table definitions using Query in Oracle?
Lvea Aem Technologies
If you are using some tools, you can select the table for which you want to show properties and th…
How to Generate a range of dates using "CONNECT BY" in Oracle?
Lvea Aem Technologies
The CONNECT BY clause specifies the link between parent rows and kid rows of the hierarchy. The co…
The Top Consulting Oracle Fusion ERP
Lvea Aem Technologies
What is ERP System? Enterprise Resource Planning (ERP) Applications Overview Financials Manufacturi…