SQL Best Practices

Introduction:

SQL has been part of every Oracle professional's life. One could be a developer, Business Analyst or even an Architect. Its important that we are good at writing better queries to write good code, or even to support your functional process definitions faster. With my 12+ years of experience in the field of Oracle, I am giving some of the best practices that I think would help others

Tips:

Format: I pay more attention while writing the queries to the formatting. So SQL statements should be formatted consistently to aid readability. Now, this is not a performance tip really. However, it’s important and part of the practices. Even you ask for help from others, it would look neat and nice for them to easily understand and concentrate on fixing the real issue than taking more time in reading your SQL.