||Oracle Tips by Burleson
Oracle 10g Unloading BFILE datatypes
9 END IF;
The get_bfile function can now be used to
populate a new table containing a BFILE column.
CREATE TABLE print_media_int AS
get_bfile (ad_graphic_dir, ad_graphic_file) ad_graphic
If we have done our homework properly,
the data in the columns of the newly loaded table should match the
data in the columns of the original print_media table.
SELECT product_id, ad_id,
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: