||Oracle Tips by Burleson
Oracle 10g Unloading Columns Containing Final Object
6 LOCATION ('proj_obj_ext.dmp')
(ps.address, NULL, 0, 1) address,
The type constructor function can now use the
columns in the external table containing the attributes of the
object type as arguments when loading data into a column of that
type. Note that the address column in the external table will be
used to determine whether to call the constructor function for the
object or set the column to NULL.
Now let's create a new internal table that
looks exactly like the projects_sources table.
CREATE TABLE projects_sources_2 AS SELECT * FROM project_sources
INSERT INTO project-sources_2
(address, 0, NULL,
city,state_or_provence, mail_code, country)),
Get the complete story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details: