pl/sql coding

Posted on 2013-11-19
Last Modified: 2013-12-14
What are the major pl/sql coding done by oracle dba..
Question by:dev_dba
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 125 total points
ID: 39661087
You seem to have asked three pretty generic questions in a row.

It would help us a lot if you can provide the context in which you have heard them.

For this question:
A DBA can use PL/SQL to assist in day-day operations, monitoring, reporting, etc...

For example:
I have several procedures that run daily that email me directly from the database on things I deem important.

Just about and DBA task can be automated in some way using pl/sql.

A lot also depends on the type of DBA:  Production or Development?

A dev DBA can assist in coding of new apps/processes.  A prod DBA can use knowledge of pl/sql for new code that may potentially cause an issue.

The more detailed you can be in your questions, then better we can answer.

Author Comment

ID: 39661263
Please do not answer to my questions.
This is  a humble request to you.
LVL 23

Assisted Solution

David earned 125 total points
ID: 39662502
Speaking as a 20-year DBA, it is very rare for me to write PL/SQL on a modern Oracle RDMBS.  A developer, OTOH, is fair game.

I will certainly use PL/SQL objects, such as the SYS supplied DBMS objects for analysis.  I may encapsulate code into a shell or job script for reuse.

If this misses your point, please clarify.

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 35

Accepted Solution

johnsone earned 125 total points
ID: 39662666
As another 20-year DBA, I will say depends on the company and what standards they adhere (or are required to adhere) to.

I definitely don't do as much PL/SQL as I used to.  But, that is because of SOX and SAS standards.  Separation of duties requires that the DBA cannot write the PL/SQL code that is in the database.  They see that as some sort of conflict of interest.

That being said, the DBAs in quite a few places I have been were responsible for all the PL/SQL code in the database.  We wrote it and maintained it.  A couple of places had a dedicated group of "DBAs" to do this, but they had no administration duties, they only wrote PL/SQL.

Other places, the PL/SQL is the responsibility of the development staff, because it is code after all.
LVL 74

Assisted Solution

sdstuber earned 125 total points
ID: 39664785
As a DBA I write PL/SQL all the time.  Sometimes for my own administrative tasks (as opposed to shell scripting).

I've written a few APEX applications which are just web pages on top of pl/sql.

I wrote and support a central set of pl/sql tools that are shared among all of our databases to do common functions like email, string and numeric manipulation and some os implementation.

I also tune and review pl/sql of developers in various departments.

I'm also called upon to write pieces of or even entire applications and integrations with pl/sql.

As the other answers above have hinted.  It's not so much the title of "dba"  it's the work and project management overlapping with available skill sets.

Also, as a side note.  rejecting the assistance of slightwv is not helpful to yourself.
His comments about vague questions are accurate.

If you want concise answers it's better to ask concise questions.

Author Comment

ID: 39684675

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question