How is oracle used in pl/sql, Database Management System

Assignment Help:

How is Oracle used in PL/SQL? Define the features of process and how they are defined?

PL/SQL - PL/SQL is Oracle's procedural language (PL) superset of the Structured
Query Language (SQL). PL/SQL is block-structured language that enables developers to code procedure, functions and unnamed blocks that combine SQL along with procedural statements. PL/SQL has its own processing engine that executes PL/SQL blocks and subprograms. If the host program does not have the PL/SQL engine, the blocks of code are sent to the Oracle server for processing. The subsequent figure displays the PL/SQL engine as integrated elements of Oracle server. The engine executes process statements and passes SQL statements to the SQL statement executor within the Oracle server.

Procedures - Sophisticated business rules and application logic can be stored as procedures inside Oracle. Stored procedures - groups of SQL and PL/SQL statements - permit you to move code that enforces business rules from the application to the database.

As a result the code will be stored once for all applications to use. Procedures can be described or created along with the CREATE PROCEDURE command. The syntax in Oracle to define a procedure is:
CREATE [OR REPLACE] PROCEDURE [.]
[( [IN|OUT|IN OUT]
[, [IN|OUT|IN OUT] ] ...)] {IS|AS}
[]
BEGIN

[EXCEPTION
WHEN THEN

[WHEN THEN

...
...]
[WHEN OTHERS THEN
]]
END;


Related Discussions:- How is oracle used in pl/sql

Durability-transaction , Durability : This property necessitates that once ...

Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas

Lock, intent locking

intent locking

Construct an er diagram for a hospital, Construct an ER diagram for a hospi...

Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.

What are metrics for choosing the best algorithm, What are metrics for choo...

What are metrics for choosing the best algorithm? Matrices for choosing the best algorithms are as below: Computational complexity Ease of understand ability and im

Find a 3nf decomposition , Find a 3NF decomposition of the following relati...

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following

I need web security expert, I need web security expert , website management...

I need web security expert , website management Project Description: i want professional for the below . website management server management database management

What is the use of rename operation, What is the use of rename operation? ...

What is the use of rename operation? Rename operation is used to rename both relations and an attributes. It uses the as clause, taking the form: Old-name as new-name.

Illustrate the definition of the classes and operation, The definition of t...

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

Private Tuition, Hi, Do you offer private tuition for DBMS?

Hi, Do you offer private tuition for DBMS?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd