Learn UNIX Certification with Free Lessons & Tips

Bash scripting can be abale to do what a c programming language can do.It doesnt have OOPS properties . As we have other languages with wider functionalities like perl and python people are not relaying on Bash scripting .Even when the data is more some times Bash scrpting behaves odd as per my personal experience

I would like to answer this from Unix perspective.

I would share a couple of experience where I saw the things went messy.

The 1st and formost thumb rule is to avoid use of find and rm in your shell script eventhough you are removing the perticular file set from a specific directory because when you are doing the trouble shooting from developer's work area then it would remove the files recursively and it would take time to realise what went wrong.

Point 2) Always have time to time backup of .ssh directory where you store the public or private keys as this is the most critical directory where you maintain server connectivity which may impact your deliverables.

Now from oracle perspective:

If you work on complex queries, run your queries and check at least thrice on different environments( where you have multiple data stored) that I am not missing any join which is leading to cartesian product.

2) check that you table doesnt contain any NULL record in the column being used in where condition because we dont always use this check ( column is not NULL)