Results 1 to 10 of 10

Thread: insert picture to table

  1. #1
    Junior Member
    Join Date
    Mar 2007
    Answers
    3

    insert picture to table

    i want to store photos of student along with their resume in a database,
    can it be possible to store it directly (without using front end) to oracle table?


  2. #2
    Expert Member
    Join Date
    Oct 2005
    Answers
    383

    Re: insert picture to table

    i think yes!
    BLOB is the data type provided to store images etc!

    :)
    NEVER SAY DIE.

  3. #3
    Contributing Member
    Join Date
    Oct 2007
    Answers
    88

    Smile Re: insert picture to table

    just give the blob (size);
    blob is the deata type


  4. #4
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: insert picture to table

    To get Details of Blob follow this link


  5. #5
    Junior Member
    Join Date
    Dec 2007
    Answers
    3

    Re: insert picture to table

    hi
    u cannot store image directly,but u can store the address of the image in the table using datatype as a blob.ok bye


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: insert picture to table

    You can use either BLOB or LONG RAW for the purpose.


  7. #7
    Junior Member
    Join Date
    May 2008
    Answers
    1

    Re: insert picture to table

    write a query to store picture in the database


  8. #8
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: insert picture to table

    you need to convert the picture to a stream of bytes and store to BLOB field


  9. #9
    Junior Member
    Join Date
    Mar 2009
    Answers
    28

    Re: insert picture to table

    you need to create a column data type as BLOB and when ever you store image in to BLOB type column it will store in the form of Binary.


  10. #10
    Junior Member
    Join Date
    Apr 2009
    Answers
    4

    Re: insert picture to table

    use blob datatype in oracle


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