Object types and collections - performance of application, PL-SQL Programming

Use Object Types and Collections

The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities and relationships map directly into the object types. A well-constructed object model can improve the application performance by eliminating the table joins, decreasing the round trips, and the same.

The Client programs, involving the PL/SQL programs, can declare the objects and collections, and pass them as parameters, store them in the database, recover them, and so on. Also, by encapsulating the operations with data, the object types move data-maintenance code out of the SQL scripts and PL/SQL blocks into methods.

The Objects and collections are well-organized to store and retrieve as they can be manipulated as an entire. The object support is also integrated architecturally with the database; therefore it can take benefit of the many scalability and performance improvements built into Oracle8i.

Posted Date: 10/5/2012 4:55:07 AM | Location : United States

Related Discussions:- Object types and collections - performance of application, Assignment Help, Ask Question on Object types and collections - performance of application, Get Answer, Expert's Help, Object types and collections - performance of application Discussions

Write discussion on Object types and collections - performance of application
Your posts are moderated
Related Questions

Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Redeclaring Predefined Exceptions Keep in mind that, the PL/SQL declares predefined exceptions globally in the package STANDARD; Therefore you need not declare them yourself.

Assignments in pl/sql The Variables and constants are initialized every time a block or subprogram is entered. By default, the variables are initialized to NULL. Therefore, unle

Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Projection and Existential Quantification - SQL Intuitively it might seem that projection in SQL is simply a matter of specifying the required columns in the SELECT clause, a