11-10-03, 11:56 #1Registered User
- Join Date
- Oct 2003
Unanswered: revised scripting/ coding question
I wrote a question last week and thanks eveyone for the response. I realized though that I wasnt very clear and Im hoping this will make more sense.
Im a MSSQL DBA. Currently, I never have to write many stored procs that users will use. I do write some though that only I use. (backups, log shipping, replication alterations, etc.) I really do enjoy writing those. Im really hate writing procs for reporting, procs that the front end apps use, etc. Ive been learning my way around VB Script a little bit as well. Dont mind that so much either. So what I should have asked last week is: Does an Oracle DBA typlically have to write procs that the front end users will eventually use? Or, when I look @ job postings for Oracle DBA's and it says I must know PLSQL, does that mean in order to write procs for my use or for the end user? I know there are know hard and fast answers and this will rely greatly on the company, but Im really looking for a typical scenario. Because MSSQL is from what I understand lots easier to administer, most shops have the dba also double as a developer. Something Im fortunately not having to do right now. Another question, someone last week mentioned being to write procs that generate scripts, how does that work?Thanks in advance.
11-10-03, 13:26 #2Registered User
- Join Date
- Jul 2003
Re: revised scripting/ coding question
The short answer is to learn/know as much as possible.
Most companies need someone to do multiple jobs.
In general, you need PL/SQL knowledge in order to extract data from
the database and to analyze and tune queries that developers write.
Not to mention whatever dataload-jobs that load data into
the db on a regular interval.
Sometimes DBAs are needed to write SPs.
If you know basic/average pl/sql then you should not have a problem.
Just follow the coding-standards document that the company will have onfile.
Eventually obataining expert knowlwdge of writing and tuning pl/sql
will pay dividends down the road. Writing SPs for months on end
eventually took me from a beginner to definitely above-average coder.
Apply that knowledge to tuning/re-writing development code
and you are on your way to being a valuable DBA.
To me, there is nothing more satisfying than taking a page that
takes 2 minutes to load and turning/tuning it into a page that
takes 1-second to load. That is bringing value to your company
right there. (and it makes you feel good too!)- The_Duck
you can lead someone to something but they will never learn anything ...