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
COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e

Example of UNWRAP Operator - SQL Example here shows how unwrapping can be done in longhand in SQL. Example: Unwrapping in SQL Letting CONTACT_INFO_WRAPPED denote the res

Brewbean's is implementing a new discount for return shoppers - every fifth completed order receives a 10% discount. The count of orders for a shopper is placed in a packaged varia

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Keyword & Parameter Description: WHEN: This keyword introduces the exception handler. You can have many exceptions execute the similar sequence of the statements by follo

Updating by replacement Syntax: UPDATE ENROLMENT SET Name = 'Ann' WHERE StudentId = SID ('S1'); Note the use of SET, as already noted in connection with direct a

Positional Notation The first procedure call uses the positional notation. The PL/SQL compiler relates the first actual parameter, account, with the first proper parameter, ac

Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

which operation is used if we are interested in only certain columns of a table?

How do I display usernames for students from a student table, assigning each student a username initials001 (initials is the actual student initials), and if the students initials