PL/SQL
«Prev
Next»
Programming PL/SQL
Querying Object Tables
Using Oracle Objects
Object Oriented Terms
Query Object Tables
Collections Varrays Oracle
Querying Nested Tables
Practical/SQL Examples
SQL Query Example
Querying Complex Object
Alternate Query Example
Object Relational Summary
Querying Related Tables
Understanding Related Object Tables
Analyzing Dangling References
Writing deref Queries
Oracle deref Syntax
Querying Object Tables
Creating PL/SQL Block
Object Relational Conclusion
Querying Nested Tables
Flattening nested Table
Flattening nested Table Example
Simple varray Query
Query to Flatten varray
Query Flattens Nested Table
Procedure retrieves Nested Table
Varrays Nested Table Conclusion
Object Table Modification
Insert into Table
SQL Insert Rows
Write SQL to Update Object Table
Subquery in Update
Delete Rows from object Table
DML Statements Conclusion
Updating Rows Example
Modifying Nested Tables
Insert Rows into Nested Table
Delete Command for Nested varray
Updating Varray Rows
inserting Data in Nested Table(Example)
Varray insert Command
Modifying LOBs
Varray Concepts - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
In what forms can Oracle store a varray?
Please select the best answer.
A.
BLOB only
B.
Raw data only
C.
Both raw data and BLOB
D.
Neither raw data nor BLOB
2.
What explains why it is more efficient to use a nested table than a varray?
Please select the best answer.
A.
A nested table allows you to update parts of the data, whereas updating parts of the data is not allowed within a varray.
B.
A varray allows you to update parts of the data, whereas updating parts of the data is not allowed within a nested table.
C.
Neither a varray nor a nested table allows you to update parts of the data.
D.
Both a varray and a nested table allow you to update parts of the data.
3.
If the application requires querying and modifying the entire collection, which collection: 1) nested table or 2) varray is the better alternative?
Please select the best answer.
A.
A nested table is the better alternative.
B.
It does not matter, you can use either.
C.
Neither are good alternatives.
D.
A varray is the better alternative.
Correct answers:
Your Score: 0
Submit
Quiz Explanation
x