RelationalDBDesign
SiteMap
PL/SQL
Stored Objects
PL/SQL Programming
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
Querying Object Tables
Creating PL/SQL Block
Object Relational Conclusion
Querying Nested Tables
Flattening nested Table
Query Flattens Nested Table
Simple varray Query
Query to Flatten varray
Flatten varray - Exercise
Procedure retrieves Nested Table
Varrays Nested Table Conclusion
Object Table Modification
Modifying Object Tables
Insert into Table
SQL Insert Rows
SQL Update Object Table
Subquery in Update
Delete Rows from Table
DML Statements Conclusion
Modifying Nested Tables
Modifying nested Varrays
Insert Rows into Table
Varray insert Command
Updating nested Table Rows
Updating Varray Rows
Delete Nested varray Command
Delete Entire Array
Nested Tables Conclusion
Modifying LOBs
Erasing Data within LOB - Exercise
Erasing Data within a LOB
Objective:
Use PL/SQL to erase portions of data within a LOB column.
Exercise scoring
This exercise is auto-scored.
Background/overview
In this exercise, you will erase data within a LOB column using PL/SQL.
Exercise Simulation
This exercise uses a simulation of an Oracle environment.
Instructions
In the following simulation exercise, you will be asked to perform a task or set of tasks you have learned in the previous lesson. The instructions will tell you what you need to do at each step but will not tell you exactly how.
Submitting your exercise
Click the
Submit
button when finished to see the suggested results for the exercise.
With SQL*Plus, connect to the database by using PETSTORE as the User Name, GREATPETS as the Password, and MYDB as the Host String. Approve the entries.
User Name
PETSTORE
S0)Type PETSTORE in the User Name box.
Password,
GREATPETS
(S0)Type GREATPETS in the Password box.
Host String,
MYDB
Type MYDB in the Host Name box
You are now connected to the database. Next, start the PL/SQL block by declaring two variables: one to store the value of the LOB and the other for the number of bytes to be erased.
Submit
