SQL

GeoChart region plugin can be used to visualize data on a google map. You can analyze and display geographic data and present it on the Google maps. Example: Population, Pollution, Sources etc. There are 3 types of map visualization modes available: Region: This mode fills entire regions such as countries, provinces, or states with colors …

Why we need?It is difficult for end user to enter exact location of the address, so we have developed plugin which allows end user to select or search address using autocomplete functionality of Google Map. With the use of this plugin you can type part of address and based on that it will populate list …

I came across a very strange issue with my SQL Developer. The connection bar is not opening/expanding/minimizing/maximizing. So, I was scared thinking that I have re-setup my SQL Developer. But, when I did a quick google search, I found that following steps should solved such issues: Go to Windows menu Click Reset Windows To Factory …

It is quite possible you could work with Oracle databases for many years and never come across the ALL, ANY and SOME comparison conditions in SQL because there are alternatives to them that are used more regularly. You can find more info on Oracle-Base Article. I hope this will be quite useful to many developers. …

Hi friends, How to calculate difference between columns of current and previous/next row? Let’s say, you want to monitor how often products are sold from your store. i.e.  You want difference between current and previous SELL_DATE then you can write query as follows: SELECT TO_CHAR(SELL_DATE, ‘DD-MON-YYYY HH24:MI:SS’), TO_CHAR(LAG(SELL_DATE) OVER (ORDER BY SELL_DATE), ‘DD-MON-YYYY HH24:MI:SS’) AS …