[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


pl/sql coding

Posted on 2013-11-19
Medium Priority
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 500 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 500 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.

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 35

Accepted Solution

johnsone earned 500 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 500 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

649 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