|
|
|
|
|
Originally posted by Remar Uy:
select *
from emp
where rownum < 11
/
Originally posted by Beksy Kurian:
Sumit,
These are the steps to insert an image into a blob column.
Step 1.
-------
Create a table to store the blobs:
create table blobs
( id varchar2(255),
blob_col blob
);
Step 2.
-------
Create a logical directory in the database to the physical file system:
create or replace directory MY_FILES as 'c:\images';
Step 3.
-------
Create a procedure to load the blobs from the file system using the logical directory.
create or replace procedure insert_img as
f_lob bfile;
b_lob blob;
begin
insert into blobs values ( 'MyGif', empty_blob() )
return blob_col into b_lob;
f_lob := bfilename( 'MY_FILES', 'whateverimage.gif' );
dbms_lob.fileopen(f_lob, dbms_lob.file_readonly);
dbms_lob.loadfromfile( b_lob, f_lob, dbms_lob.getlength(f_lob) );
dbms_lob.fileclose(f_lob);
commit;
end;
/
Hope it helps
Beksy
Originally posted by Thomas Paul:
In fact, it uses RMI over IIOP.
