1

Oracle - Performing Top-N Queries

by Syed Aziz ur Rahman 8. February 2006 03:34

The task of retrieving the top or bottom N rows from a database table (by salary, sales amount, credit, etc.) is often referred to as a "top-N query." This task is fairly common in application development. As you might know that there is NO top clause in PL/SQL causing problems for the developers coming from T-SQL environment. But there are certian ways to do that in Oracle. Read More...

Tags:

Oracle

0

Oracle - Rename a Table Column Without Any Data Manipulation

by Syed Aziz ur Rahman 8. February 2006 03:29

As counterintuitive as it is, Oracle databases have no SQL command for assigning a new name to a table column yet they have such a command for renaming an entire table. So, when I peruse Oracle database discussion groups, I frequently see the question "how do I rename a table column in my database?"  Read More...

 

Tags:

Oracle

Powered by BlogEngine.NET 2.5.0.6
Original Design by Laptop Geek, Adapted by onesoft