REM bfiledml.sql
REM Version 1.0, last updated 8/8/97
REM This block demonstrates some DML operations on external LOBs, as
REM described in Chapter 21 of _Oracle8 PL/SQL Programming_ by Scott Urman.BEGIN
-- Create a row in lobdemo pointing to an external file.
INSERT INTO lobdemo (key, bfile_col)
VALUES (5, BFILENAME('util', 'file1')); -- Copy this locator into lobdemo2.
INSERT INTO lobdemo2
SELECT *
FROM lobdemo
WHERE key = 5;
END;
/------------------------
| |
| 相逢何必曾相识 |
| |
------------------------
REM Version 1.0, last updated 8/8/97
REM This block demonstrates some DML operations on external LOBs, as
REM described in Chapter 21 of _Oracle8 PL/SQL Programming_ by Scott Urman.BEGIN
-- Create a row in lobdemo pointing to an external file.
INSERT INTO lobdemo (key, bfile_col)
VALUES (5, BFILENAME('util', 'file1')); -- Copy this locator into lobdemo2.
INSERT INTO lobdemo2
SELECT *
FROM lobdemo
WHERE key = 5;
END;
/------------------------
| |
| 相逢何必曾相识 |
| |
------------------------
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货