Purpose: It is a dummy table in Oracle with one row and one Varchar2 column whose length is 1. It's structure looks as under SQL> Desc Dual; Name Null? Type ----------------------------------------- --...

Let Us Learn Oracle - Part 30 of N [ VSize function of Oracle ] Purpose: It returns the number of bytes in the internal representation of expression. If expression is null, it returns null. SQL> Select EMPNAME, VSize(EMPNAME) VSizeExample 2 ...

Let Us Learn Oracle - Part 41 of N [ Cume_Dist function of Oracle ] It acts both as Aggregate and analytic function. Analytic Example Purpose: Within a group of rows, it calculates the cumulative distribution of a value in a group of values. Synt...

Part 01 of a 3 part summary on Microsoft TechEd (India) 2012 held in Bengaluru (Bangalore) from March 21-23, 2012 at the Lalit Ashoka Hotel. I attended TechEd 2012 as a TechEd Rockstar....

As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to open query window at default when opening ...

It's time for a change. This website, BeyondRelational.com, is rolling out a new Blogs module with improved features, feedback and social opportunities. All 146 of my posts have been moved to the new location: http://beyondrelational.com/modules/2/blogs...

Talk about strange error with date interpretations (encountered only at MSSQL2005) depending on languages versions....

...

...

Recently i was asked by my friends to delete the files bases on number of files, not based on days. Such a way we can keep number of files every time and rest files get archived. I will give you an example here as i have three folders and want ...