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;
Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit
Find out the names and company names of all employees sorted in ascending order of company name and descending order of employee names of by which company. SELECT EMPLOYEE_NAME,
Identify the need and use of data control through problem solving, illustration
Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each fore
Determine the Strong and Weak Entity Based on the method of foreign key, there might be arise a situation when we have to relate an entity having a primary key of its own and a
What are the advantages and disadvantages of merging an association into a class? Advantages: i) Less number of tables ii) Faster performance due to the fewer tables
explain participation constraints with examples
What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is
What is the role of ORDER By Clause? ORDER BY clause: The ORDER BY clause permits you to sort the records in your result set. The ORDER BY clause can just be used in select s
What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low
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