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

Describe embedded query language, Describe Embedded Query Language? Emb...

Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

MANAGEMWNT OF PRINCILES AND TECHNIQUES., HOW TO SOLVE THE LP Problems by si...

HOW TO SOLVE THE LP Problems by simplex method?z=x1+-3x2+2x3

What is meant by normalization of data, What is meant by normalization of d...

What is meant by normalization of data? It is a process of examining the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the prop

What are data models, What are data models? Explain it detail? Entity ...

What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

Alter table command, ALTER TABLE Command : This command is used for variati...

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

Explain dynamic two-phase locking, Explain Dynamic Two-Phase Locking H...

Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item.  After finishing all the operations on

What is a security, What is a security? Securities are claims on financ...

What is a security? Securities are claims on financial assets.  They can be illustrated as "claim checks" which give their owners the right to receive funds in the future.  Sec

Give an example of enforcement in typing, Give an example of enforcement in...

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

Top down method and bottom up method, Evaluate, compare and contrast the tw...

Evaluate, compare and contrast the two methods of relational database design namely top down method and Bottom up method. What will be your choice if you are asked to select a meth

What do you mean by an execution plan, What do you mean by an execution pla...

What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat

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