-
Junior Member
LOBs
Hi
How are large binary objects used?
How can we upload a photo into a database?
thanks,
Radhi.
-
Expert Member
Re: LOBs
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 ***
-
Junior Member
Re: LOBs
Hi Innila,
Can we insert an image or a sound clip into database using sql?
Thanks,
Radhi
-
Expert Member
Re: LOBs
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 ***
Last edited by Innila; 02-23-2007 at 08:00 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules