Virtual Columns in Oracle 11g R1

I just found out this good feature in Oracle 11g release 1. How many times you felt tired because you were coding again and again for a particular function while selecting data from table? Consider the following table. The table contains employee name, date of joining. Year of joining will not be stored in database [...]

Width Bucket – Analytic Function

WIDTH_BUCKET function is used to assign bucket value for a list of values based on maximum and minimum number. This is one of the new analytic function introduced in Oracle 10g. Consider the following table. StudentId Mark 1 56 2 43 3 76 4 89 5 90 6 91 7 49 8 63 9 83 [...]