Results 1 to 2 of 2
  1. #1
    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.

  2. #2
    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 ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts