**Utility: Delimited Files Comparison Using Oracle**

A Configuration based oracle database utility to compare delimited files with similar structure and produce difference report. It can also compare two database tables with similar structure (columns, data type etc) and find differences. The report can be saved in oracle table or as a text file on server.

https://github.com/promisinganuj/Programming/tree/master/Oracle_Table-Comparision-Utility

Utility: Loading Excel files in Oracle using C#

A simple utility to load excel files directly into Oracle database. As it uses ClosedXML and Excel Data Reader, there is no need to have Excel installed on the machine. The program variations use threading, hash tables and classes to do the same.

https://github.com/promisinganuj/CSharp_Load-Excel-Files-To-DB

A simple utility to load excel files directly into Oracle database. As it uses ClosedXML and Excel Data Reader, there is no need to have Excel installed on the machine. The program variations use threading, hash tables and classes to do the same.

https://github.com/promisinganuj/CSharp_Load-Excel-Files-To-DB

**Presentation: Understanding Redo and Undo in Oracle**

Based on Tom Kyte's Expert Oracle, this presentation is aimed for Developers / DBAs who want to understand the basics of Redo and Undo and how these work together. No rights claimed, feel free to download, use and distribute.

oracle_architecture-redo_and_undo.pdf | |

File Size: | 613 kb |

File Type: |

A small demonstration of how formulas (and cell formats) can be read directly as a configuration and applied to cells in excel macros. Every time there is a requirement, the formulas can be updated in the configuration and will be picked up dynamically by macro from next time onwards.

http://viralpatel.net/blogs/excel-macro-evaluating-formulas-dynamically/

**Demonstration: Evaluating formulas dynamically using Excel Macro**A small demonstration of how formulas (and cell formats) can be read directly as a configuration and applied to cells in excel macros. Every time there is a requirement, the formulas can be updated in the configuration and will be picked up dynamically by macro from next time onwards.

http://viralpatel.net/blogs/excel-macro-evaluating-formulas-dynamically/

## Row Data Multiplication in Oracle

Ever wondered that we don't have a aggregate function for multiplication in Oracle. No MUL () function is available for row data multiplication. Check out how it can be done with the help of Mathematics.

http://viralpatel.net/blogs/2010/11/row-data-multiplication-in-oracle.html

http://viralpatel.net/blogs/2010/11/row-data-multiplication-in-oracle.html

## Generating Random data in Oracle

Due to regulatory requirements/compliance issues, usually no production data is allowed in development environment. There is always a need to generate test data, which is random but looks alike the actual production data. This blog provides a simple sql for such requirement

http://viralpatel.net/blogs/2010/07/generating-random-data-in-oracle.html

http://viralpatel.net/blogs/2010/07/generating-random-data-in-oracle.html

## Deleting Duplicate Rows in Oracle

This article summarizes different ways of deleting duplicate data in Oracle tables. I haven't done any performance comparision here.

http://viralpatel.net/blogs/2010/06/deleting-duplicate-rows-in-oracle.html

http://viralpatel.net/blogs/2010/06/deleting-duplicate-rows-in-oracle.html

## Oracle Data Compression

Here, I tried to explain the basic concept used by Oracle to compress table data. It will be an interesting thing to know how the compression is actually working behind the scene.

http://viralpatel.net/blogs/2010/06/oracle-data-compression.html

http://viralpatel.net/blogs/2010/06/oracle-data-compression.html

## Understanding Primary Keys

The behaviour of Primary keys in Oracle has been demonstrated. People new to oracle can find few interesting things here like primary key enforcement using non-unique index.

http://viralpatel.net/blogs/2010/02/understanding-primary-keypk-constraint-in-oracle.html

http://viralpatel.net/blogs/2010/02/understanding-primary-keypk-constraint-in-oracle.html