NoviceNovice
2008
3
Oracle
> Email nilesh doshi (login required)

nilesh doshi's Articles

Rating
Date

How To Code a Matrix Report in SQL

March 12, 2008
By nilesh doshi
This article shows how to generate Matrix reports. Matrix reports are also know as "Crosstab" reports.

How To Add Day, Hour, Minute, Second to a Date Value in Oracle

March 3, 2008
By nilesh doshi
Date arithmetic is widely used in many database applications. This article is about how to add Day, Hour, Minute, Second to a Date value in Oracle.

How To Get Rid of Duplicate Rows in an Oracle SQL Table

January 31, 2008
By nilesh doshi
Duplicate records can be deleted. Duplicate records can be prevented using Unique Indexes.