Results 1 to 4 of 4

Thread: LOBs

  1. #1
    Junior Member
    Join Date
    Feb 2007
    Answers
    10

    LOBs

    Hi
    How are large binary objects used?
    How can we upload a photo into a database?
    thanks,
    Radhi.


  2. #2
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    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 ***


  3. #3
    Junior Member
    Join Date
    Feb 2007
    Answers
    10

    Re: LOBs

    Hi Innila,

    Can we insert an image or a sound clip into database using sql?
    Thanks,
    Radhi


  4. #4
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact