Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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 StructuredQuery 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;
What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with
Which data type can store unstructured data? Raw data type can store unstructured data.
What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that
What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.
Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher
Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200
Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs
3 assignments combined in 1
What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec
After the completion of the logical model the physical model is to be made. The oracle 10 G will be used as a database server and all the tables with their column are created and i
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd