Normally when we need to compare DATE type where only DATE (i.e DD/MM/YYYY) component holds the significant, we need to [...]

[Read more →]

Few days back I wrote about virtual indexes which help us in checking the impact of indexes on SQL query [...]

[Read more →]

Let me share with you guys new test which I did:
I again created following two functions, this time without exception:
CREATE [...]

[Read more →]

Whenever One need to fetch column value from table I have seen following two variance of coding. One is straight [...]

[Read more →]

Recently I came across term called Virtual Index or some call it fake indexes. I will use term Virtual Index [...]

[Read more →]

With this new statement CONTINUE, one can skip to the next iteration in a loop.
Even though this is a small [...]

[Read more →]

While going through a thread in Oracle Forums, I came across ‘SAMPLE’ clause which is used in SELECT statement to [...]

[Read more →]

Today I came across very simple but important concept which may look simple but can give a headache if we [...]

[Read more →]

Today when checking “Search Keyphrases” for my site, I found out that someone wants to know about ‘can we use [...]

[Read more →]

Today I found out this very interesting fact about default value.
While inserting or updating we can use reserver word “DEFAULT” [...]

[Read more →]