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
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
Types Oracle Lobs
CreateTable Using LobColumn
Dbms_lob Package Components
Retrieving Large Object
Inserting LobData Technique
Inserting Lob Data
Updating Lob Data
Deleting Lob Data
Modify Table Lob Conclusion
Inserting LOB data using SQL*Loader - Exercise
Objective:
Load data into object tables with the LOB data type.
Exercise Scoring
This AI scored exercise is worth 10 points.
Background
Load data into object tables with the
LOB
data type.
Fact File
Review the fact file to find out more information about the House-O-Pets and their Oracle 8i database.
Click on the link below to view the dat a table to see the contents of the tables in the House-O-Pets database.
Data Tables
Scenario
The purpose of this exercise is to help you understand the relationship between Pet Stores and Large Objects in Oracle
Instructions
To load data into the object table, you require two main files and one log files. The two main files are a control file (ppot.ctl) and a datafile (ppot.dat). Create a control file to load data into
PRODUCT_PHOTO_OBJ_TABLE
.
Create a datafile to load data into
PRODUCT_PHOTO_OBJ_TABLE
. Run SQL*Loader to load data by passing on the following parameters: USERID/password, name for the control file, name of the log file, name of the datafile, and name of the bad file.
Hints
Set
USERID = petstore/greatpets
.
Now answer this....
Please answer the following questions in the text box below to submit your answers to the tutor.
1. What is the requirement of a .ctl file?
2. What is the prerequisite process before loading data into LOBs using SQL*Loader?
Submitting your exercise
Type (or cut and paste) your plan into the box below to submit your answers to a tutor. Click the
Submit
button when finished to submit the exercise. Remember to submit all of your answers at once.