Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Unanswered: how can we store .jpg or .bmp file in database

    I want to know the method to store picture file in database.

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    There is a column type BLOB which can be used to store pictures.


    Rgs,
    Breen.

  3. #3
    Join Date
    Sep 2003
    Location
    Delhi
    Posts
    15
    Hi,
    You can also store it in the OS file system...and reference it through a pointer to that particular .jpg or .bmp...But u need to create a table with a bfile datatype.I had done that a few yrs back so I don't remember the exact syntax...Just look up OTN for the exact syntax

    Bye,
    Pinaki

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •