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
LVL 76

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.

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

LVL 34

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 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now