Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    15

    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.
    ChrisR

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296

    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
  •