Skip to content

why is sql important for a new oracle dba career?

Why is sql important for a new dba?

A new oracle dba should know sql because of the following reasons

1)All applications connect to the oracle database and run sql statements either to update the database or insert new data into the database or to bring back data from the case any sql statement has a problem a new dba should be able to troubleshoot and fix the problem with the sql statement.

2)If a new dba wants to find out what is going on in the database then he has to open sqlplus or another tool like TOAD and write simple select statements to read data from some important oracle internal tables/ having very good knowledge of sql will help in troubleshooting and fixing database problems quite fast.

3)when you are a production dba , your development team will give you some oracle sql scripts that you must install on the database.If you dont want to make mistakes while installing these scripts then you should have knowledge of sql and sqlplus.

so go ahead and read the articles in the sql and pl/sql categories in the left hand side list box

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Post a Comment

You must be logged in to post a comment.