How to find a file on Linux
There are zillions of small little Linux commands that make life easy. Those tiny little commands may save you hours of time and tons of frustration. Wheneever I look as…
There are zillions of small little Linux commands that make life easy. Those tiny little commands may save you hours of time and tons of frustration. Wheneever I look as…
This post provides info on how data may be added on a Big Data platform with help of Hive and Impala. We start with a dataset that is stored on…
To drop a table is straightforward in Oracle. One might simply issue a drop table statement. Let us assume we have table HH. When “drop table HH” is fired, the…
Transpose a record in Oracle isn’t easy. I had a small table with several records and one value in a record. I wanted to transpose that table into one record…
The SQL Loader is a facility that allows you to load data files blazingly fast. It is able to do as data files are directly written to disk without any…
Oracle allows you to calculate a distance between two points. Such calculation is not trivial as one must take into account that distances are calculated over the globe and the…