Hi
How are large binary objects used?
How can we upload a photo into a database?
thanks,
Radhi.
Printable View
Hi
How are large binary objects used?
How can we upload a photo into a database?
thanks,
Radhi.
Hi Radhi,
Large Objects (LOBs) are a set of datatypes that are designed to hold large amounts of data.
A LOB can hold up to a maximum size ranging from 8 terabytes to 128 terabytes depending on how your database is configured.
Storing data in LOBs enables you to access and manipulate the data efficiently in your application.
BLOB, CLOB, NCLOB, BFILE are Large Object Datatypes.
BLOB datatype can used to store multimedia data like images, audio & video.
*** Innila ***
Hi Innila,
Can we insert an image or a sound clip into database using sql?
Thanks,
Radhi
Hi Radhi,
Definitely u can insert an image or a sound clip into database using SQL.
Here is a sample insert query where the photo column has datatype BLOB,
insert into emp(id,name,cust_photo) values(l_id, l_name, l_photo_Blob_datatype );
*** Innila ***