Apr
20
question != right-question
April 20, 2007 | Leave a Comment
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 way […]
Apr
15
DDBA
April 15, 2007 | Leave a Comment
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 […]
Apr
6
COALESCE
April 6, 2007 | Leave a Comment
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 […]
Apr
4
Name Parser
April 4, 2007 | Leave a Comment
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 […]
Apr
4
Flashback Queries
April 4, 2007 | Leave a Comment
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 more flexibility to detect […]