Database SQL





1. Get single records when duplicate records exist

Here is a SQL tip about how to get single records when duplicate records exist in a table.

2. Find duplicate values or non-duplicate values in a table

Tips for retrieving duplicated and non-duplicated values in Oracle.

3. How to get Top 1 record from Oracle by using PL/SQL

This article explains how to use Oracle function to select the top 1 record from Oracle by using PL/SQL.

4. How to get Top N rows from Oracle by using SQL

To get top N records from Oracle is tricky and there are basically three ways to get them by using Oracle SQL.

5. Convert MS Access Northwind database to Oracle

In this article, we are going to convert the popular Microsoft Access Northwind database to Oracle. Many of the database objects like constraints, index, auto number, etc., are migrated to relevant Oracle objects.

   Inside this article:

• How the data types in Access Northwind are converted to Oracle
• Building Oracle Northwind database objects
• Queries to generate aggregated data for Oracle Northwind database

6. How to do cross table update in Oracle

This article shows you 4 ways to do cross table update in Oracle.

(Listing 1 - 6 of 6)  First | Prev | Next | Last