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

North indian plains, i am not clear with the climetic condition of the nort...

i am not clear with the climetic condition of the north indian plain. can u plz explain it for me

Describe the development process of object oriented methods, Describe the d...

Describe the development process of Object oriented methods Object oriented methods have roots which are strongly anchored back in the 60s, functional and structured methods we

Management information system, management information system based on funct...

management information system based on functional organisation

Data replication, Data Replication "If a relation R has its copies kept...

Data Replication "If a relation R has its copies kept at two or more sites, then it is considered replicated". But why do we replicate a relation? There are several advan

Which operator is used to compare a value to a list literals, Which operato...

Which operator is used to compare a value to a list of literals values that have been specified? BETWEEN operator is used to compare a value to a list of literals values that h

What are composite attributes, What are composite attributes? Composite...

What are composite attributes? Composite attributes can be separated in to sub parts.

View serialiabilty-labelled precedence graph, how to construct labelled pre...

how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

Differentiate between key and superkey, Differentiate between Key and super...

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o

Increases efficiency-data fragmentation, Increases efficiency : Data is sto...

Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

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