Kirtan Desai

Analytic functions: All my findings regarding analytic functions will go in this post. In other words I will keep on adding my finding to this post instead of creating new one all the time. I will also make sure that everytime when I update this post I bring up to the top of the list [...]

The following is a list of books. There are three sections. First is the name of the book that I am currently reading. Second is the list of books that I am going to read in near future. And third is a list of books that I have read. Currently reading…   The Inheritance of [...]

I was reading tom kyte’s blog and found the following link there. I am not trying to copy/steal what he had there but I thought this was extremely important to publish. Not just for others but to keep reminding myself. I think, for anyone who wants to learn anything, asking right questions is the only [...]

There is an excellent article by Doug Burns here regarding the role of an individual who acts as either Developmentt DBA, Developer/DBA, DBA/Developer etc. The bottom line, as pointed out in the article, is that in a development environment where a DBMS is at the center of the project/application/system, individual(s) with strong knowledge of the [...]

COALESCE is one of many convenient ways provided by oracle to handle NULL values in the database. The Oracle COALESCE function accepts a varying length list of arguments and returns the first non-NULL value/expr in the list. If all arguments in the list evaluate to a NULL value, then the COALESCE function will return a [...]

There was a question asked on InformaticaDevelopement yahoo group about parsing names. I had a piece of code saved from asktom. I don’t know when I got it from asktom, but I know I got it from asktom. I just wanted to put it out here for reference. To parse names you would have to [...]

Flashback features were there in 9i. 10g is providing something new/extra. ### From new features guide  ### What if you ever need to do a resetlogs operation for recovery purposes, you can take the database back to a point in time before the resetlogs if you find that you made a mistake. This provides administrators [...]

I just wrote this procedure below that does duplicate file (dataset, i should say) check. Let’s say, you have a system where your clients/users have rights to write straight to your “staging” or “landing” tables. You have a system where multiple users are feeding multiple files everyday. You have a requirement to check whether users [...]

Fun times or “geek times” I should say started last weekend. So I finally gave vista a chance. Since I was involved with beta testing of Vista, they sent a licensed Vista Ultimate Edition to me. So now I have Windows Vista Ultimate on my new laptop. The first thing that I do when get [...]